Home > mailing lists

Re: [GENERAL] CREATE TABLE AS - Mailing list pgsql-general

From	David Warnock
Subject	Re: [GENERAL] CREATE TABLE AS
Date	January 24, 2000 10:44:32
Msg-id	388C435B.38B4AF98@sundayta.co.uk Whole thread Raw
In response to	unicode (Mitja Novak <mitja@mail.velenje.cx>)
List	pgsql-general

Tree view

Chai,

Just miss out the order by, it has no meaning in a table definition.

ie

Create table blah2 as
select pin from tbs_billing_record
where date(start_time) between '01-JAN-2000' and '23-JAN-2000';

Dave

pgsql-general by date:

From: Chairudin Sentosa Harjo
Date: 24 January 2000, 09:44:31
Subject: CREATE TABLE AS

From: "Kwon, YongChul"
Date: 24 January 2000, 11:05:32
Subject: about password authentication

Re: [GENERAL] CREATE TABLE AS - Mailing list pgsql-general

Previous

Next