Antw: [SQL] - Mailing list pgsql-novice

From Gerhard Dieringer
Subject Antw: [SQL]
Date
Msg-id s92ce8e7.056@kopo001
Whole thread Raw
List pgsql-novice
gomathi raju wrote:

> I want to get the system timestamp from postgresql database.
> But I dont have a dual table from where ,I can select it.
> Give me a solution, from which table(system) I can get it.

Unlike Oracle, you don't need a from clause in postgreSQL.
You can just say

    select some_expression;

without from dual

Gerhard



pgsql-novice by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: [HACKERS]
Next
From: "Michael A. Mayo"
Date:
Subject: Re: [SQL]