| From: | "Roderick A(dot) Anderson" <raanders(at)altoplanos(dot)net> |
|---|---|
| To: | "PostgreSQL::General List" <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Fake table name? |
| Date: | 2000-10-02 21:05:46 |
| Message-ID: | Pine.LNX.4.10.10010021358250.12140-100000@altoplanos.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I know I've seen this but can't even begin to guess where that was so I'll
ask. I need to add a fake entry to a UNION. A row that doesn't exist in
the table and shouldn't. It's for a CGI script where I want the user have
the all/none/whatever option.
select tbl_key, equipname from equipment
UNION
select 'All', 'All Equipment' from ???
Heck I can't even remember what is was called in Oracle.
TIA,
Rod
--
Roderick A. Anderson
raanders(at)altoplanos(dot)net Altoplanos Information Systems, Inc.
Voice: 208.765.6149 212 S. 11th Street, Suite 5
FAX: 208.664.5299 Coeur d'Alene, ID 83814
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Carmody | 2000-10-02 22:07:17 | RE: Fw: Talking with other Dbases. |
| Previous Message | Serg King | 2000-10-02 20:08:06 | NULL value in one argument will clear all arguments in server-side functions ( plpgsql ) to NULL?! |