insert question.. - Mailing list pgsql-general

From Williams, Travis L, NPONS
Subject insert question..
Date
Msg-id AB815D267EC31A4693CC24D234F8291604D64137@ACCLUST02EVS1.ugd.att.com
Whole thread Raw
Responses Re: insert question..
Re: insert question..
Re: insert question..
List pgsql-general
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

Thanks,

Travis

pgsql-general by date:

Previous
From: Liviu BURCUSEL
Date:
Subject: How to find the definition of a sequence ?
Next
From: Adam Witney
Date:
Subject: Re: How to find the definition of a sequence ?