Re: [SQL] How to configure two netcard for PostgreSQL?

2003-03-30 Thread dailiming
Yes, I have already set the two Ip address in the pg_hba.conf file . But It do nothing. So I htought adding some messages in the router table may be a way. Thanks. - Original Message - From: "Peter Eisentraut" <[EMAIL PROTECTED]> To: "dailiming" <[EMAIL PROTECTED]> Cc: "Bruno Wolff III"

[SQL] PHP LINK module (RPM format) for PostgreSQL V7.3

2003-03-30 Thread jack
Hi, All Please advise where I can get the PHP LINK module (RPM format) for PostgreSQL V7.3. Thank you in advance! Jack ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [SQL] to_number

2003-03-30 Thread Kaare Rasmussen
> > How can to_number work with Danish locale? > It looks like you have "C" locale instead of Danish one. What happens when > you change your system locale to Danish?. Seems to use the settings in postgresql.conf, NOT pg_settings. I don't know what they are used for. So it seems that PostgreSQL

Re: [SQL] to_number

2003-03-30 Thread Tomasz Myrta
> # SELECT * FROM pg_settings WHERE name LIKE 'lc_%'; > name | setting > -+- > lc_messages | unset > lc_monetary | C > lc_numeric | C > lc_time | C > (4 rows > > SELECT price, to_number(price,'D9)') FROM orderline WHERE sku = > '01-0082-4'; > price | to_n

[SQL] to_number

2003-03-30 Thread Kaare Rasmussen
# SELECT * FROM pg_settings WHERE name LIKE 'lc_%'; name | setting -+- lc_messages | unset lc_monetary | C lc_numeric | C lc_time | C (4 rows SELECT price, to_number(price,'D9)') FROM orderline WHERE sku = '01-0082-4'; price | to_number ---+--