Re: [HACKERS] Porting to Native WindowsNT/2000

2001-09-01 Thread Ian Lance Taylor
"Dwayne Miller" <[EMAIL PROTECTED]> writes: > Well, for one I have no idea what cygwin is, or what it does to > your system, or what security vulnerabilities it might add to your > system. It comes with alot of stuff that I may or may not need, but > what components I need to run Postgres

Re: [HACKERS] Porting to Native WindowsNT/2000

2001-09-01 Thread Dwayne Miller
Well, for one I have no idea what cygwin is, or what it does to your system, or what security vulnerabilities it might add to your system. It comes with alot of stuff that I may or may not need, but what components I need to run Postgres is not clear. Two could Postgres be made more

Re: [HACKERS] Porting to Native WindowsNT/2000

2001-09-01 Thread mlw
Dwayne Miller wrote: > > I understand that the current port of Postgres for Windows requires the > cygwin package. I'd like to understand the requirement for cygwin,and > possibly try to port Postgres to run natively on Windows as a NT/2K > service. Anyone like to identify the challenges in suc

[HACKERS] Porting to Native WindowsNT/2000

2001-09-01 Thread Dwayne Miller
I understand that the current port of Postgres for Windows requires the cygwin package. I'd like to understand the requirement for cygwin,and possibly try to port Postgres to run natively on Windows as a NT/2K service. Anyone like to identify the challenges in such a port? Is it at all poss

Re: [HACKERS] INTERVAL type: SQL92 implementation

2001-09-01 Thread Ken Hirsch
Thomas Lockhart <[EMAIL PROTECTED]> wrote: > We have a copy of an SQL99 draft which seems to be reasonably complete. > afaik we haven't come across an actual released version. Let me know if > you want me to forward it; perhaps it is on the ftp or web site? ftp://ftp.postgresql.org/pub/doc/sql/s

[HACKERS] DIVIDEBY in PostgreSQL

2001-09-01 Thread Vladimir V. Zolotych
Hi Would you mind to tell me how the DIVIDEBY operator could be defined (the way Codd E.F [1] or Date C.J [2] define it) in PostgreSQL ? Using PostgreSQL 7.1.2 Thanks in advance. 1 Codd E.F. Relational Completeness of Data Base Sublanguages 2 Date C.J. An Introduction to Database Systmes 6th

Re: [HACKERS] Escaping strings for inclusion into SQL queries

2001-09-01 Thread Peter Eisentraut
For consistency with the rest of the libpq API, the function should be called PQescapeString, not PGescapeString. Bruce Momjian writes: > > Your patch has been added to the PostgreSQL unapplied patches list at: > > http://candle.pha.pa.us/cgi-bin/pgpatches > > I will try to apply it within

Re: [HACKERS] Re: Escaping strings for inclusion into SQL queries

2001-09-01 Thread Peter Eisentraut
Florian Weimer writes: > The first version escaped ' with ''. I changed it when I noticed that > if \' is used instead, the same function can be used for strings > ('...') and identifiers ("..."). Last time I checked (15 seconds ago), you could not escape " with \ in PostgreSQL. The identifer