On Friday 04 May 2001 06:32, you wrote:
> Type reltime is old and deprecated. Don't use it.
What should we be using instead?
--
Sincerely etc.,
NAME Christopher Sawtell
CELL PHONE 021 257 4451
ICQ UIN45863470
EMAIL csawtell @ xtra . co . nz
CNOTES ftp://ftp.funet.fi/pu
* Ligia Pimentel <[EMAIL PROTECTED]> menulis:
> I need to know if there is a sql function implemented in postgres that gives
> me a date plus any number of days, months or years (the traditional dateadd
> function) or how to do it in sql?
cepat=# select '01-01-00'::date + '2 months 10 days'::inte
On Dom 29 Abr 2001 22:34, LeoDeBeo wrote:
> can anybody explain me the syntax of Create Table documentation??
>
> CREATE [ TEMPORARY | TEMP ] TABLE table (
> column type
> [ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ]
> [ column_constraint_clause | PRIMARY KEY } [ ... ]
On Sun, 29 Apr 2001, LeoDeBeo wrote:
> can anybody explain me the syntax of Create Table documentation??
This doc is much improved in the more recent PG create table help.
Check out the online 7.1 Reference Manual, and there's a much nicer CREATE
TABLE grammar.
--
Joel Burton <[EMAIL PROTEC
LeoDeBeo <[EMAIL PROTECTED]> writes:
> i don't understand what the curly brace means after PRIMARY KEY (where is
> the other matching brace?
Typo. Try more recent versions of the docs. 7.1 says
CREATE [ TEMPORARY | TEMP ] TABLE table_name (
{ column_name type [ column_constraint [ ... ]
[ Charset ISO-8859-1 unsupported, converting... ]
> On Mon, Mar 12, 2001 at 09:21:58PM -0500, Tom Lane wrote:
> > Spy <[EMAIL PROTECTED]> writes:
> > > Tom Lane a ?crit :
> > >> Is that actually how MySQL interprets two parameters? We treat them
> > >> as count and offset respectively, which defi
On Wed, 2 May 2001, Ligia Pimentel wrote:
> I need to know if there is a sql function implemented in postgres that gives
> me a date plus any number of days, months or years (the traditional dateadd
> function) or how to do it in sql?
Just add a date and an interval. Something like:
date + '1
can anybody explain me the syntax of Create Table documentation??
CREATE [ TEMPORARY | TEMP ] TABLE table (
column type
[ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ]
[ column_constraint_clause | PRIMARY KEY } [ ... ] ]
[ , ... ]
[ , PRIMARY KEY ( column
I need to know if there is a sql function implemented in postgres that gives
me a date plus any number of days, months or years (the traditional dateadd
function) or how to do it in sql?
Thanks in advance for any help
Ligia
---(end of broadcast)
You're trying to compare apples and oranges. Since the field is of type
text, it will sort by text. Therefore, the result will be 1 then 10 then
1a and so forth. It is sorting based on ASCII. The only way to get it to
sort in proper numerical order is to make the field a numeric field. But
of cour
> "LP" == Ligia Pimentel <[EMAIL PROTECTED]> writes:
LP> I need to know if there is a sql function implemented in postgres
LP> that gives me a date plus any number of days, months or years (the
LP> traditional dateadd function) or how to do it in sql?
Here's what I use:
select CURRENT_DATE
Thus spake Subhramanya Shiva
> i could not find chkpass in pgsql datatypes ...
> it is giving error called :
>
> Unable to locate type name chkpass in catalog.
>
> what shall i do ??
You need the code that I just committed. You can get the files from
http://www.ca.postgresql.org/cgi/cvsweb.cg
12 matches
Mail list logo
