[SQL] Re: BLOB HOWTO??

Maybe the functions lo_import and lo_export is what you're looking for? regards, robert gravsjo Olivier PRENANT wrote: Hi, Beeing very impressed by TOAST, I wonder how I can insert BLOB from a flat file. It seems quite easy with php; But how can I do it from psql?? TIA

[SQL] Emergency case: Postgres problems

Dear Sir, I will highly appreciated if anyone could inform me how to solve the following problems in Postgres. Specifically,sometimes thereare the following messages informed by postgres. NOTICE: Message from PostgreSQL backend: The

[SQL] How to modify type in table?

Dear Sir. Would you like to inform me how to modify type in table? For example , I define type as varchar(14) , but I want to modify to varchar(120). How to do this. Thank you so much Jaruwan

[SQL] Re: [HACKERS] BLOB HOWTO??

Bruce, Thanks for replying (I know you're a busy man :) Any chance to have it backported to 7.1 or maybe in contrib??? This is a feature w all gonna lack (with GiST...) Regards, On Mon, 29 Jan 2001, Bruce Momjian wrote: Hi Bruce, Any idea when it's due for?? I've been thining about

[SQL] Problem with Day of Week

Greetings, I notice some talk about date problems and interestingly enough planning out an application in which I will need to be able to manipulate dates. I notice however that there seems to be a discrepancy with the day or week in 7.0.3 --- pmhcc=# select date_part('dow','now'::timestamp);

[SQL] RE: C function for use from PLpgSQL trigger

You could send the column name directly into your c function. For example: c_function_name(NEW.col1, NEW.col2, NEW.col3). Otherwise I am not sure how to send NEW into a C function. You could try declaring NEW in your C function as a tuple. -Original Message- From: Joe Conway

[SQL] Re: [HACKERS] BLOB HOWTO??

I'm interested by TOAST, and I have asked several questions on the subject... I haven't tested them yet... First I thought that the type bytea allows storing of binary data, a BSOB (Binary Small OBject). Secondly that by using a binary cursor you have access to the raw data as it is stored in

Re: [SQL] Problem with Day of Week

On Mon, Feb 05, 2001 at 05:15:47PM +0100, Karel Zak wrote: test=# select date_part('dow','2001-02-11'::timestamp); date_part --- 0 test=# select to_char('2001-02-11'::timestamp, 'D'); to_char - 1 date_part is based on zero - use range 0-6 to_char

Re: [SQL] Problem with Day of Week

On Mon, 5 Feb 2001, Ross J. Reedstrom wrote: On Mon, Feb 05, 2001 at 05:15:47PM +0100, Karel Zak wrote: test=# select date_part('dow','2001-02-11'::timestamp); date_part --- 0 test=# select to_char('2001-02-11'::timestamp, 'D'); to_char - 1

Re: [SQL] HELP: Scarey pl/pgsql problem

Justin Clift [EMAIL PROTECTED] writes: I'm having trouble with what MAY BE a bug in PL/PGSQL for PG 7.0.3 on Linux (Mandrake Linux 7.2). [ bogus roundoff behavior in date/time display ] This is a known silliness in the Mandrake distribution: their default compiler flags include both -O3 and

Re: [SQL] How to modify type in table?

Saluton, On Tue, Jan 30, 2001 at 10:22:23AM +0700, Jaruwan Laongmal wrote: Dear Sir. Would you like to inform me how to modify type in table? For example , I define type as varchar(14) , but I want to modify to varchar(120). How to do this. If it is not too much data, the easiest would be

[SQL] how to simulate UPdate ...?

I not run update in Pgsql please tell me other method thanks == update table1 a set na1= (select table2.na1 from table2,table1 where table1.no=table2.no and a.no=table1.no);

Re: [SQL] SQL Join - MySQL/PostgreSQL difference?

Brice Ruth writes: SELECT a.Number, a.Code, a.Text FROM b, a WHERE (b.Id = a.Id) AND (VersionId = 'key1') AND (Category = 'key2') AND (b.d_Id = 'key3') ORDER BY a.Number; (my apologies: I had to 'mangle' the table/column names because of NDA) So my question

Re: [SQL] SQL Join - MySQL/PostgreSQL difference?

On Thu, 1 Feb 2001, Brice Ruth wrote: -SELECT - a.Number, - a.Code, - a.Text -FROM - b, - a -WHERE - (b.Id = a.Id) AND These next two statements are very ambiguous. Make them explicit as you have with "(b.Id = a.Id)" and "(b.d_Id = 'key3')" Also, be sure that 'key3' is how what you want

[HACKERS] Re: How to modify type in table?

I am compiling postgresql 7.1beta4. How would i change the 8k row limit? There is no 8k row limit anymore. But if there were, you would modify a #define in the source code and recompile (check the docs for more details). - Thomas

[GENERAL] Re: SQL Join - MySQL/PostgreSQL difference?

Ian, Thanx - I figured the same about the ambiguity. I'll keep tryin' to debug this with the vendor, then. -Brice Ian Harding wrote: Brice Ruth wrote: Greetings. I'm working with a product provided by a third part that interfaces to data housed in a database of your choice.

[SQL] Tuple is too big ...

Hello all, I am running PostgreSQL-7.0.3. I changed the value of BLCKSZ (in "include/config.h" to 16384, recompiled and reinstalled the sources. After having restarted the backend I tried to create a table with three varchar(5000)-columns and tried to add three character-values with each 4000