[GENERAL] looking for multi-language app example using postgresql

2005-11-02 Thread YL
I tried but have very little progress on this. If any one know where to find an multi-language example (php prefered) using postgresql, please let me know. Thanks [EMAIL PROTECTED]

[GENERAL] test

2005-04-02 Thread YL
please ignore -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 4/1/2005 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] psql and mysql

2005-04-02 Thread YL
Dear List, I'm new to Psql and very eager to learn the differences between these two RDBMS. Any help is greatly appreciated. Thanks -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 4/1/2005 --

[GENERAL] cygwin and psql

2005-04-04 Thread YL
I'm installing psql to my laptop where cygwin is installed. I got the warning for removing the cygwin\bin from the path and re-start the installer.   It's not hard to remove cygwin from the path. Does qsql need to remove cygwin permanently?   Thanks No virus found in this outgoing message. Ch

[GENERAL] multi-languages in a table

2005-06-23 Thread YL
I'm migrating from mysql to postgresql. I've several (mysql)tables with multi-language columns:   descript, descript_gb, descript_b5, descript_sp   they store the record's description in English, SimplifiedChinese, TraditionalChinese and Spanish respectively.   I don't know if this will wo

Re: [GENERAL] pgmonitor

2005-08-01 Thread YL
i want to list non-system tables with psql and get the following error. any alternatives? Thanks. EPost-# \dt ERROR: invalid byte sequence for encoding "UNICODE": 0xed my database used UNICODE as the encoding. and the OS is win2k pro wich simplified chinese as default language. --

[GENERAL] user defined function

2006-01-24 Thread Yl Zhou
I want to implement a UDF that can accept a parameter which is a tuple of any table, and returns the number of NULL attributes in this tuple. Different tables may have different schemas. How can I implement this function?  Thanks. andrew

Re: [GENERAL] user defined function

2006-01-24 Thread Yl Zhou
Do you mean this function? Seems I cannot get much information from it.../* * record_out        - output routine for pseudo-type RECORD. */Datumrecord_out(PG_FUNCTION_ARGS){    elog(ERROR, "Cannot display a value of type %s", "RECORD");     PG_RETURN_VOID();            /* keep compiler quiet */}On

Re: [GENERAL] user defined function

2006-01-24 Thread Yl Zhou
But I have to use 7.3 due to some limitations. Can I do it in 7.3? On 1/24/06, Tom Lane <[EMAIL PROTECTED]> wrote: Yl Zhou <[EMAIL PROTECTED]> writes: > Do you mean this function? Seems I cannot get much information from it...That would appear to be Postgres 7.3 :-(You need a con

Re: [GENERAL] user defined function

2006-01-24 Thread Yl Zhou
Can anyone tell me whether 7.3 supports unspecified record types or not? On 1/24/06, Tom Lane <[EMAIL PROTECTED]> wrote: Yl Zhou <[EMAIL PROTECTED]> writes:> Do you mean this function? Seems I cannot get much information from it...That would appear to be Postgres 7.3 :-( You need