| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: insert question.. |
| Date: | 2003-06-11 14:53:34 |
| Message-ID: | bc7fkj$iek$2@main.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Williams, Travis L, NPONS schrieb:
> I'm looking for an example on how to insert static data and information from a select at the same time..
>
> currently I'm doing:
>
> insert into performance (start,finish) select min(poll_time),max(poll_time) from poll
>
> I need to add a 3rd field that is static so I would have something like this
>
>
> insert into performance (name,start,finish) travis,select min(poll_time),max(poll_time) from poll
>
insert into performance (name,start,finish)
select 'Travis', min(poll_time),max(poll_time) from poll
Cheers
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-06-11 14:54:44 | Re: How to find the definition of a sequence ? |
| Previous Message | Thomas Kellerer | 2003-06-11 14:52:48 | Re: How to find the definition of a sequence ? |