sql to select where (('name','age') in (('dan',30),('eric',40))

[danielspaniel]

Hi
I am trying to do a select like that above where
I want to select rows that match the columns and values
exactly.

so for example I want to do this:

select * from people
where (('name','age') in (('dan',30),('eric',40))


to get the 2 people who have the name and age pair matching ('dan',30) and ('eric',40).

this sql runs fine in mysql but not in pervasiveSQL.
Is this not possible? Am I missing something?

~ Daniel

 

[mirtheil]

What is the behavior in PSQL? Does it return a syntax error or incorrect results?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com