Re: Variables in PostgreSQL? [was: Is my MySQL Gaining?]

From: "Chris Travers" <chris(at)travelamericas(dot)com>
To: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, "Casey Allen Shobe" <cshobe(at)softhome(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Variables in PostgreSQL? [was: Is my MySQL Gaining?]
Date: 2003-12-29 02:13:20
Message-ID: 008201c3cdb6$cf15a4f0$9944053d@winxp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general pgsql-hackers

The other problem though is that I might want to SET the variable from a
query result. Is there any way I can do that within psql?

For example, something that would allow me to run a query, set the variable
from the query result and then use that variable in another set of queries.
This would drastically help on maintaining upgrade scripts for my db's.

Best Wishes,
Chris Travers

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Alex Satrapa 2003-12-29 03:16:03 Re: Is my MySQL Gaining ?
Previous Message Chris Travers 2003-12-29 01:56:35 Re: Is my MySQL Gaining ?

Browse pgsql-general by date

  From Date Subject
Next Message Alex 2003-12-29 02:59:15 pg_recvbuf errors
Previous Message Chris Travers 2003-12-29 01:56:35 Re: Is my MySQL Gaining ?

Browse pgsql-hackers by date

  From Date Subject
Next Message Alex Satrapa 2003-12-29 03:16:03 Re: Is my MySQL Gaining ?
Previous Message Andrew Dunstan 2003-12-29 02:09:56 Re: Use of 'cp -r' in CREATE DATABASE