| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
| Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: select only default |
| Date: | 2003-05-16 02:30:59 |
| Message-ID: | 20030516023059.GA23312@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Fri, May 16, 2003 at 01:32:03 +0200,
Nabil Sayegh <postgresql(at)e-trolley(dot)de> wrote:
> Hi all,
>
> just for curiosity:
>
> Is it possible to SELECT a row that consists only of default values of a
> table ?
There is probably some way to get the data out of the system tables. If
the defaults are constants you might be able to easily present it.
However, for what you are doing it may be better to put the defaults
in a separate table and get them from there. You will have to create
a function(s) for getting the default values since you can't use
select in a default clause.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ville Jungman | 2003-05-16 08:29:33 | Re: select only default |
| Previous Message | Nabil Sayegh | 2003-05-15 23:32:03 | select only default |