sql question

From: Joseph Shraibman <jks(at)p1(dot)selectacast(dot)net>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: sql question
Date: 1999-12-08 02:14:37
Message-ID: 384DBF0D.DF9C29AB@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Is there any way to get something like this into valid sql? Postgres
doesn't like this:

INSERT INTO application (key, creator, name) values ( 1 ,(select userkey
from
user where username = 'b' ), 'newapplication') ;

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Douglas Thomson 1999-12-08 04:34:33 Re: [INTERFACES] locking on database updates
Previous Message Assaf Arkin 1999-12-08 01:07:33 Transaction support in 6.5.3/JDBC