[SQL] how to r/w blob field in php

hi, everyone I decide to use text field to store large text but pgsql has 8k limit in insert statement. I have read the sample of create large object of pg_sql in the php manual. here it is: Example 1. Using Large Objects 1 2 13 I am confused. According this sample, but which t

Re(2): [SQL] optimize sql

[EMAIL PROTECTED] writes: >How does the output of the above differ from: > >SELECT name FROM office, office_application >WHERE code = office_code >AND active != 't'; > >Without knowing the table structures (which tables to active, code, >and office_code belong to?) it's hard to suggest much els

Re: [SQL] optimize sql

On Wed, Jul 26, 2000 at 10:11:15PM +0800, pgsql-sql wrote: > HI! > > The SQL below is too slow. > > SELECT name FROM office, office_application > WHERE code = office_code > AND name NOT IN > (SELECT DISTINCT name FROM office, office_application > WHERE active = 't' AND code = office_code); >

[SQL] optimize sql

HI! The SQL below is too slow. SELECT name FROM office, office_application WHERE code = office_code AND name NOT IN (SELECT DISTINCT name FROM office, office_application WHERE active = 't' AND code = office_code); Can anyone tell me how to optimize it? Thanks.

Re: [SQL] Change attribute of a column

Hello, I asked a similar question before and it seems there is no way but using pg_dump. Question to the developers: Is it planned to make type changing (and casting) possible with ALTER TABLE or the like? Volker Bernie Huang wrote: > > Hi, > > I have a field in text[] and I want to change i

[SQL] Exec query

Hi, what's the diffence, and is it well? : PgDatabase data(dbname) ; -> data.ExecCommandOk("SELECT * FROM table") ; -> data.ExecTuplesOk("SELECT * FROM table") ; thanks.