Re: [SQL] Contributing Documentation to PG

Roberto Mello writes: > I finally came around to writing some extra documentation for PL/PgSQL > (and maybe PL/Tcl) and how to do PL/SQL-to-PL/PgSQL porting. I saw this on your site -- very nice. Can you give use the source code, so we can integrate it? > I downloaded the documenta

Re: [SQL] How to insert values with a new type ?

[EMAIL PROTECTED] writes: > complexe * complex_in(float x, float y) > { > complexe *result; > result = (complexe *)palloc(sizeof(complexe)); > result->x = x; > result->y = y; > return (result); > } A datatype's input routine has to accept a string (char *).

[SQL] COPY and UNICODE encoding

Hello, I am using jdbc interface to load my data and Postgresql 7.02. I want to use copy command to load data from a unicode file. How can I notify the server that the encoding of the file is unicode and not the default encoding of the file system. Thanks in advance Regards Sofia Alexaki

[SQL] How to insert values with a new type ?

Hi, I have the following program : #include typedef struct complexe { float x; float y; } complexe; complexe * complex_in(float x, float y) { complexe *result; result = (complexe *)palloc(sizeof(complexe)); result->x = x; result->y = y; return (result); }