Re: [GENERAL] setting and using variables in PSQL ????

2007-12-15 Thread Andreas Kretschmer
Gauthier, Dave <[EMAIL PROTECTED]> schrieb: > > > Hi: > > At the PSQL prompt, I want to set some variables based upon query results, or > via static assignment, then insert a record with those values. Sort of > like... You can use this: - define in your postgresql.conf: custom_variable_c

Re: [GENERAL] setting and using variables in PSQL ????

2007-12-14 Thread Nathan Wagner
On Dec 14, 2007, at 9:19 PM, Gauthier, Dave wrote: At the PSQL prompt, I want to set some variables based upon query results, or via static assignment, then insert a record with those values. Sort of like... select val1 into x from agedata where name = ‘joe_mako’; select val12 into y from

[GENERAL] setting and using variables in PSQL ????

2007-12-14 Thread Gauthier, Dave
Hi: At the PSQL prompt, I want to set some variables based upon query results, or via static assignment, then insert a record with those values. Sort of like... select val1 into x from agedata where name = 'joe_mako'; select val12 into y from sizedata where name = 'joe_mako'; thename :=