| From: | "Jie Liang" <jie(at)stbernard(dot)com> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | \set |
| Date: | 2004-05-11 23:07:04 |
| Message-ID: | E7E213858379814A9AE48CA6754F5ECB36336D@mail01.stbernard.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
Hi,
How to use an internal variable?
Original question was how to set a variable in postgresql?
If I want to set a variable like start_date='2004-05-10';
How could I use it in my SQL statement?
E.g.
Db> set start_date '2004-05-10'
Db> select start_date as 'start date';
It's not executable!
Thanks.
Jie Liang
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Bjorklund | 2004-05-12 04:03:41 | Re: [PERFORM] Quad processor options |
| Previous Message | Paul Tuckfield | 2004-05-11 22:46:25 | Re: [PERFORM] Quad processor options |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gary Stainburn | 2004-05-12 10:02:31 | view problem - too many rows out |
| Previous Message | Bruce Momjian | 2004-05-11 20:23:18 | Re: Adding MERGE to the TODO list (resend with subject) |