[SQL] RE : [SQL] Convert text from UTF8 to ASCII

Hi Perhaps you should try to set your db client_encoding to UTF8. How do you know you have 'patiënt' instead of 'patiënt'? I mean i also deals with UTF8 databases and all i store is correctly stored. But i can't check it with command line psql as my shell is configured with iso-8859-1

[SQL] unsubscribe

[SQL] unsubscribe ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[SQL] Trigger to identify which column(s) updated

key of a record? Thanks, Jack ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[SQL] The problems about temporary tables in V7.3.2

removes the access priority of the temporary tables. Jack ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

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

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

[SQL] EXECUTE problem on schema

Hi, all postgreSQL v7.3.3 I found EXECUTE on pl/pgsql doesn't support schema. When I specify a table such as public.tablename, it reported not such a relation object. The only SQL statement I used is update. Don't know wether other statements have the same problem. Jack

Re: [SQL] the best way to get some records not in another table

Hi, According to the following report, I think using except would be the best way to do. Thank you! Jack EXPLAIN SELECT DISTINCT a.c1 FROM test_j2 a WHERE a.c1 NOT IN (SELECT DISTINCT b.c1 FROM test_j1 b); Unique (cost=54544.91..54547.41 rows=50 width=6) - Sort

Re: [SQL] pl/pgsql how to return multiple values from a function

Stephan , Both of two suggestion work. Thank you very much! Jack ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] About Create Type

Thanks Joe. Yes, that is exactly what I need. Jack ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [SQL] pl/pgsql how to return multiple values from a function

Thanks Rajesh. It 's very useful reference site. Jack ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing

[SQL] Inquiry From Form [pgsql]

Dear Sir/Madam, I would like to find out two things: 1)Do you have a function which is similar to Oracle\'s DECODE. 2) Can you extract day of week (Monday,etc) from yours date functions. Kind Regards, Jack Kiss ---(end of broadcast)--- TIP 3

[SQL] window version of psql of postgreSQL v7.3.1

Hi, all Where can I get a window version of psql of postgreSQL v7.3.1? Thank you very much! Jack ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] quastions about primary key

Is that possible to have a two columns primary key on a table with null value on second column? Jack ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

[SQL] A problem about alter table

Hi, all I'm using postgreSQL 7.2.3. The following statement always cuases a parser error, parse error at or near NOT. Please adivse, thank you in advance. ALTER TABLE _acct_group1 ALTER groupkey SET NOT NULL; Jack ---(end of broadcast

Re: [SQL] A problem about alter table

But on postgreSQL 7.2 reference manual, there is a statement for alter table such as, ALTER TABLE [ ONLY ] table [ * ] ALTER [ COLUMN ] column { SET | DROP } NOT NULL Do you mean this one hasn't been implemented? Jack - Original Message - From: Tomasz Myrta [EMAIL PROTECTED

[SQL] is numeric relational operator problem fixed in v7.3

Does the following now works in postgreSQL v7.3? Select * from a_table where num1 10; *** type of num1 is NUMERIC (12,2) Jack ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

[SQL] numeric problems

NUMERIC type to FLOAT type? Please advise, thank you in advance. Jack ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] time limit of a database connection

I use a window client to conncet to a postgreSQL server with windows ODBC. It seems if I haven't done anything on the connection for hours, the connection will be dropped. Is that possible to set the time limit of a connection? Thank you in advance! Jack ---(end

[SQL] array variables in pl/pgsql

Is there any sample to show how to use array variable in PL/pgsql? How do I get an array from a table and do a loop to manipulate every element in that array? jack ---(end of broadcast)--- TIP 2: you can get off all lists at once

[SQL] array variable in pl/pgsql

Hi all Is there any sample to show how to use array variable in PL/pgsql? How do I get an array from a table and do a loop to manipulate every element in that array? jack ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

[SQL] Client Applications come with PostGreSQL V7.1

Is there any Windows version of all Client Applications come with PostGreSQL V7.1? Jack ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] execute client application from PL/pgSql

Is that possible to execute a client application from server site by PL/Pgsql, such as pg_dump? Because my client sites are running Windows OS, or is there any Windows version of all Client Applications come from PostGreSQL V7.1? Jack ---(end of broadcast

Re: [SQL] Re: psql win32 version

Hi, Christopher Thank you for your help, but the URL http://www.zeos.dn.ua/download/ipgsql-1.6.2.zip is a broken link. Would you please check again. Thank you very much. Jack - Original Message - From: "Christopher Sawtell" [EMAIL PROTECTED] Newsgroups: comp.databases.post

RE: [SQL]

Can I be removed from this mailing list? -Original Message- From: Yury Don [SMTP:[EMAIL PROTECTED]] Sent: Monday, October 30, 2000 6:55 AM To: [EMAIL PROTECTED] Subject: Re: [SQL] Hello Lengyel, Once, Monday, October 30, 2000, 5:36:23 PM, you wrote: LF Hello

[SQL] unsubscribe

unsubscribe application/ms-tnef

[SQL] error 3122 in ACCESS -

[FieldName])*([FieldCreatedbyanEarlierExpressioninQuery]) }. 1st - What is a transform statement? 2nd- What is an aggregate function? 3rd - Would I need to change anything is SQL... and what? 4th- Why wouldn't the same expression work with a different field? Jack Schlobohm