[HACKERS] About the behavior of array_length() for empty array

2012-04-05 Thread iihero
--- t I just think any "empty" array length should return 0, but not null. It's not a NULL array. Is there standard definition of this behavior? -- ------ iihero(Xiong He) http://www.sql9.com --

Re: [HACKERS] About postgresql8.3.3 build in MS VS2005

2008-10-11 Thread iihero
mail list, which says that there is one at http://winpg.jp/~saito/pg_work/OSSP_win32/ Now all the build can pass well. Thanks so much. Maybe the document can be updated for this. 2008/10/8 Magnus Hagander <[EMAIL PROTECTED]> > iihero wrote: > > Thanks. Now the header file include

Re: [HACKERS] About postgresql8.3.3 build in MS VS2005

2008-10-07 Thread iihero
Thanks. Now the header file include issues resolved. I fetch the latest code and no such issues. But I found new issues now. (the latest code from cvs) 1. file : contrib\fuzzystrmatch\dmetaphone.c, line: 1040 and line: 464, both look like as below, case '?: There is no the matched single qu

Re: [HACKERS] About postgresql8.3.3 build in MS VS2005

2008-10-06 Thread iihero
ed to install the Platform SDK properly. > > //Magnus > > > iihero wrote: > > When I build pgsql via perl after run the command line env of VS2005, > > there are lots of following error: > > > > > > > > > > e:\learn\db_research\postgresql\sour

[HACKERS] About postgresql8.3.3 build in MS VS2005

2008-10-06 Thread iihero
When I build pgsql via perl after run the command line env of VS2005, there are lots of following error: e:\learn\db_research\postgresql\source\postgresql-8.3.3\src\include\port .h(83): error C2146: syntax error : missing ')' before identifier 'hProcess' e:\learn\db_research\postgresql\source\

[HACKERS] About the parameter of API: PQprepared

2008-09-25 Thread iihero
In libpq, the definition is like: PGresult * PQprepare(PGconn *conn, const char *stmtName, const char *query, int nParams, const Oid *paramTypes) Could we remove the parameter "nParams"? e.g. "insert into foo(id, name, address) values ($1, $2, $3)" PostgreSQL possibly can parse the prepare