[SQL] Storing image contents in TEXT fields

2001-06-26 Thread Jerome Alet
Hi, I wanted to know if it's possible to store an image content in a TEXT field, or if another type is needed (in this case, then which one ?). I don't want to use BLOBs, because I modify an existing application which also works with MySQL, and I can't update to postgresql-7.1.x (I don't admin t

Re: [SQL] Plsql Function with error: No space left on device.

2001-06-26 Thread Tom Lane
"David M. Richter" <[EMAIL PROTECTED]> writes: > The query works, but not right.(apart from the timeaspect) > UPDATE image SET seriesoid = r.parentoid > FROM image i JOIN relseries_image000 r ON i.chilioid=r.childoid; You shouldn't mention "image i" in the FROM clause --- since image is already

Re: [SQL] loosing connection after function call

2001-06-26 Thread Tom Lane
Markus Wagner <[EMAIL PROTECTED]> writes: > I would like to put one table create command into a C function > "my_init", just to provide a simple interface for all tables where these > tables are needed. When I execute "select my_init();" I loose the > database connection (pgaccess). What Postgres

Re: [SQL] Problems using a rule with the WHERE clause

2001-06-26 Thread Tom Lane
Luis Sousa <[EMAIL PROTECTED]> writes: > I think this code is OK ! You probably don't want the second and third rules to be INSTEAD. However, > But I got the error message bellow in line 11 > of my script, that corresponds to the rule updateturnodocente_default > > psql:dev/pessoal/def/views

[SQL] Nested Transactions

2001-06-26 Thread John Hasler
Can anyone give me an estimate of when we might expect to see nested transactions implemented? -- John Hasler [EMAIL PROTECTED] (John Hasler) Dancing Horse Hill Elmwood, WI ---(end of broadcast)--- TIP 6: Have you searched our list archives? http:

[SQL] TEXT field size

2001-06-26 Thread Antti Linno
Hallo. Maybe its not the right list, but does the Postgres 7.1 support now unlimited text field? In previous versions it was limited to max 31k, or even less, depending on the compilation etc. Greetings, Antti ---(end of broadcast)--- T

[SQL] Changing datatype of a column

2001-06-26 Thread Ilan Fait
Title: Changing datatype of a column   Hi,   I would like to Know if there any way (and what is the command for that)  to convert a column datatype   from int4 to numeric(11)  of an existing table that have data in it?