Re: [INTERFACES] how to obtain column info

From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
To: "Cary B(dot) O'Brien" <cobrien(at)access(dot)digex(dot)net>, ken(at)ori-ind(dot)com (Ken J(dot) Wright)
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] how to obtain column info
Date: 1998-11-11 11:44:22
Message-ID: l03110702b26f28d65c54@[147.233.159.109]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

At 3:34 +0200 on 11/11/98, Cary B. O'Brien wrote:

> I usually do a 'select * from table_x where oid < 0' or something like
> that to get an empty result set.

I always maintain that it's more elegant to write

SELECT *
FROM table_x
WHERE 'false'::bool;

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Gene Selkov Jr. 1998-11-11 16:56:16 Re: [INTERFACES] need information about storing methods
Previous Message Herouth Maoz 1998-11-11 09:56:29 Re: [INTERFACES] Determine data type of columns