I learned that there is an on commit clause by looking at the
Compaitiblity section of the 7.3.3 docs and I was confused whether it
is supporting this or not
rgds
Antony Paul
On Wed, 9 Feb 2005 00:19:41 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Wed, Feb 09, 2005 at 06:00:5
Hi all,
This is giving error in 7.3.3.
CREATE TEMP TABLE temptest3(col int PRIMARY KEY) ON COMMIT DELETE ROWS;
ERROR: parser: parse error at or near "ON" at character 51
Is this supported.
rgds
Antony Paul
---(end of broadcast)---
Hi,
I read about xmin in a thread on optimistic concurrency control.
Can you guys tell me how to interpret this value. I want to convert
this to date format. Is it possible ?
rgds
Antony Paul
---(end of broadcast)---
TIP 5: Have you checked our
Thanks Tom it worked.
rgds
Antony Paul
On Mon, 10 Jan 2005 08:39:50 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Richard Huxton writes:
> > Antony Paul wrote:
> >> I need to use ORDER BY clause in a UNION query and the Order BY
> >> columns are not included
Hi,
I need to use ORDER BY clause in a UNION query and the Order BY
columns are not included in the SELECT statement. I tried like this
(select from a) UNION (select . from b) order by a.ename;
It says that
ERROR: Attribute "ename" not found
How to do this.
rgds
A
Hi all,
Is it possible to know when a row was last updated. Using 7.3.3.
rgds
Antony Paul
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that
Hi all,
What are the characters used for pattern matching with PostgreSQL
7.3. I know it is using % and _ . Any other characters ?.
rgds
Atnony Paul
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.po
Hi all
What is the last value in a column of data type timestamp without time
zone. A sample data is 2004-06-22 18:07:00.486027. What does 486027 mean
Milliseconds or seconds since midnight or something else ?
Antony Paul
---(end of broadcast
