On Sat, 28 Nov 2009, Bruce Momjian wrote:
> Rob Napier wrote:
>> I suggest that you combine the two ideas:
>>
>>>>> INSERT INTO pg_mug VALUES('coffee', 'water', 'sugar', 'cream');
>>
>> And
>>
>>>> BEGIN;
>>>> CREATE TABLE postgresql (mug_id SERIAL);
>>>> COMMIT;
>
> You mean:
>
> BEGIN;
> CREATE TABLE pg_mug (contents TEXT);
> INSERT INTO pg_mug VALUES('coffee', 'sugar', 'cream');
> COMMIT;
>
> ?
>
> I don't think "water" makes sense unless you are making instant coffee,
> which I think is atypical.
Ummm ... last I checked, that query will fail with too many fields? :)
----
Marc G. Fournier Hub.Org Hosting Solutions S.A.
scrappy@hub.org http://www.hub.org
Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:scrappy@hub.org