Re: INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Marco Lazzeri <marcomail(at)noze(dot)it>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Marco Lazzeri <marco(at)noze(dot)it>
Subject: Re: INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE
Date: 2003-11-06 10:59:18
Message-ID: Pine.LNX.4.44.0311061157360.28273-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marco Lazzeri writes:

> I need some examples of INSERT and UPDATE of DATE columns using
> 'ALLBALLS' and 'INFINITY' values. I could not find examples on the net.

These values are only supported by the type timestamp, not by date.

> I need, also, to move columns in tables (just like the MOVE BEFORE/MOVE
> AFTER MySQL commands). Can you help me?

This is not possible in PostgreSQL. Your best bet is to drop the table
and recreate it. Alternatively, do surgery using ADD COLUMN and DROP
COLUMN.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-11-06 11:08:09 Re: Problems with PLPGSQL
Previous Message Pavel Stehule 2003-11-06 10:39:25 Re: Problems with PLPGSQL