Select exists

Hi there,

I was wondering if there is currently a good way of performing a ‘select exists’, to check whether a specific row exists.

I could use the exists expression as a subquery, but this is not the same as the select exists if I only want to check if a record exists without returning the values.

Thanks a lot, I appreciate it. I could just perform a raw query but there might be some better solutions.

Dan•4/1/23, 1:14 PM

Yes, we have the operator, you can import it from

smokeOP•4/1/23, 2:15 PM

That operator requires a subquery though, in a where condition. For example, how would I perform the following query, since this only returns a boolean which is the most efficient way of checking whether a record exists or not (using Postgres):

Dan•4/1/23, 2:39 PM

Ah I see, in that case you should be able to do it like this:

Dan•4/1/23, 2:40 PM

Looks intimidating, I know

Dan•4/1/23, 2:43 PM

Actually, if that's your whole query, it won't work like this, because currently you must use

.from()

.from()

in the main query. So you can use a semi-raw query to achieve what you need:

smokeOP•4/1/23, 3:03 PM

Thanks a lot! I appreciate it