psql question

From: mtooker(at)magma(dot)ca (Mark Tooker)
To: pgsql-general(at)postgresql(dot)org
Subject: psql question
Date: 2002-11-09 00:10:12
Message-ID: e7d929b4.0211081610.6d200514@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

The following 'SELECT' query fails in psql, but it works
in Oracle sqlplus ...

mydb=# create table emp
mydb-# (firstname varchar(255),lastname varchar(255),empno int);
CREATE
mydb=# insert into emp (firstname,lastname,empno) values ('John','Doe',1234);

INSERT 44968 1
mydb=# select empno from emp where ((firstname,lastname) IN
mydb-# (('John','Doe'),('Joe','Blow')));
ERROR: parser: parse error at or near "'"
ERROR: parser: parse error at or near "'"

Whereas in sqlplus:

SQL> select empno from emp where ((firstname,lastname) IN
2 (('John','Doe'),('Joe','Blow')));

EMPNO
----------
1234

Can anyone tell me what syntax _will_ work in psql?

Many thx,
Mark

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Scherrey 2002-11-09 01:21:46 Re: Configuring postgresql build to handle long names
Previous Message Nicole Lefresne 2002-11-09 00:03:56 Referential Integrity Problem on UPDATE