Re: [HACKERS] 6.3 patches - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] 6.3 patches
Date
Msg-id 199801111246.HAA18415@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] 6.3 patches  ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>)
List pgsql-hackers
>
> Some more items from my list which have been added since v6.2.1:
>
> SQL92 binary and hex input and string type coersion
> allow casting of non-constants using both SQL92 and Postgres syntax
> parser support for PRIMARY, FOREIGN KEY
> backend support for PRIMARY KEY, UNIQUE (create index)
> more parser support for DEFAULT, CHECK clauses
> add 'doy' as argument to datetime_part()
> functions datetime_time(), time(datetime)
> functions int4_datetime(), int4_timespan()
> add unixdate package to contrib area
> constant CURRENT_USER as GetPgUserName()
> support SQL3 syntax TRUE, FALSE
> implement IS TRUE, IS FALSE, IS NOT TRUE, IS NOT FALSE
> provide timezone support in libpq and backend
> support SQL92 "delimited identifiers" (libpq, scan.l, psql)
> PGTZ environment variable for frontend
> fix session initialization from front-end environment variables
> use PGDATESTYLE to initialize backend at startup
> add GERMAN date style
> allow alternate locations for databases
> add hash functions for datetime, timespan
> fix hash function declarations for float8 and int4
> convert text to/from int4, int2
>
> Also, we've added UNIONs (didn't see it on Bruce's list).

I was just highlighting fixes to things currently on the TODO list under
reliability.


--
Bruce Momjian
maillist@candle.pha.pa.us

pgsql-hackers by date:

Previous
From: Peter T Mount
Date:
Subject: Re: [HACKERS] grant broken
Next
From: Bruce Momjian
Date:
Subject: Re: [DOCS] new psql commands