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
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
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 :=