Re: [GENERAL] CREATE TABLE AS

From: David Warnock <david(at)sundayta(dot)co(dot)uk>
To: chai(at)prima(dot)net(dot)id
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] CREATE TABLE AS
Date: 2000-01-24 12:19:39
Message-ID: 388C435B.38B4AF98@sundayta.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kwon, YongChul 2000-01-24 13:00:25 about password authentication
Previous Message Chairudin Sentosa Harjo 2000-01-24 11:42:05 CREATE TABLE AS