Re: [SQL] column type for pdf file

the large object interface provides. A bytea column is typically easier to use, and has proper transactional behavior, enforcement of referential integrity, etc. -Eric

[SQL]How to transform table rows into Colum?

value3 1 23 2500 2600300 what should i do ? I read about the crosstab function in postgresql but still have no idea on how to use it to solve this problem. Any help would be appreciated Regards -- Eric Ndengang Datenbankadministrator Affinitas GmbH

RES: [SQL] Datetime problem

date is in GMT? Thanks for all your help. []'s Eric Lemes > -Mensagem original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] nome de Tom Lane > Enviada em: segunda-feira, 14 de junho de 2004 11:56 > Para: Eric Lemes > Cc: [EMAIL PROTECTED] > Assu

[SQL] Datetime problem

Hello there,   I'm with a little trouble with postgresql and date/time conversions:   - select to_timestamp('2004 10 10 00 00 00', ' MM DD HH MI SS')   the output is:   - 2004-10-09 23:00:00-03   Anybody can help me?     []'s   Eric Lemes de Godoy Cintr

[SQL] view running query

I run an application which connects to my pgsql DB. How could I see which query is sent to DB when, an example, i push some application button (such ´find´). sds Eric Anderson CPD Via Net SAO 11-66432800 ---(end of broadcast

[SQL] \D TO FILE

How could I record the ´ \d table ´ command to a file? sds Eric Anderson CPD Via Net SAO 11-66432800 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [SQL] Is there a more elegant way to write this query?...

d, count(*) as ctCases, max(case_id) as case_id from actor_case_assignment group by actor_id) as s1 on (actor.actor_id = s1.actor_id) left outer join case_data using (s1.case_id=case_data.case_id) limit 1000; If you don't need the public_id, then you don'

Re: [SQL] SRF Functions don't want to return empty tuple

- Original Message - From: "Stephan Szabo" <[EMAIL PROTECTED]> To: "GRIMOIS Eric" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 6:40 PM Subject: Re: [SQL] SRF Functions don't want to return empty tuple > >

[SQL] SRF Functions don't want to return empty tuple

turning tuple What's wrong ? I guessed null values returned by the query didn't match fields declared not null in the table schema, so I create a custom type (with CREATE TYPE) but it neither doesn't work. Hint (?) : I've activated Plpython for this

[SQL] update system table?

how could I fix this problem:   ERROR:  unexpected chunk number 8 (expected 0) for toast value 6935693   It appear to be simple: update chunk_seq from 8 to 0. how to do it?   in the stand alone postgres, could I copy a entire table? how to do it?   tnx   Eric  

[SQL] unexpected chunk value

Reindex ran ok, but the pg_dump still returns this error.   any ideas. tnx Eric 

[SQL] Using contrib/fulltext on multiple tables

ve tried breaking it into two scripts (one for db structure and one for test data) but it still doesn't do the indexing on c. I apologize for the length, Eric ---(end of broadcast)--- TIP 2: you can get off all lists at once with th

Re: [SQL] One to many query question

olutions. For your case I prefer the added tables as they enforce the possible list of genre's. Its also handy to keep them seperate to get the list of genre's to display in a UI. Eric ps: aliasing all the table names is just my habit, do it however you see fit. I also dont like to mak

Re: [SQL] One to many query question

le varchar(25), genre_id varchar(25) references genre (genre_id) ); > How do I write a query to find all CDs that are NOT Rock? A co-worker > showed me the following query: Now the query is simple: SELECT cd.*, genre.genre FROM cd, genre WHERE cd.genre_id = genre.genre_id AND

Re: [SQL] locks and variable substitution

On Fri, 2003-07-25 at 11:49, [EMAIL PROTECTED] wrote: > > lock table excl_table in exclusive mode; That probably wont work, but this will: EXECUTE ''LOCK TABLE '' || quote_ident(excl_table) || '' IN EXCLUSIVE MODE''; Eric

Re: [SQL] yet pg_toast reindex

which index? could you help me again? Eric Anderson Martins Miranda Net Admin @ Via Net SAO - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Eric Anderson Vianet SAO" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, June 1

Re: [SQL] yet pg_toast reindex

Sorry about this sucks thread but now i´v got following error ERROR: relation "pg_toast_26474986" is of type "t" I looked for "type t" around documentation and don´t find something usefull. tnx Eric Anderson Martins Miranda Net Admin @ Via Net SAO - Original

[SQL] yet pg_toast reindex

ame error. how could I reindex it? tnx Eric Anderson Martins Miranda Net Admin @ Via Net SAO ---(end of broadcast)--- TIP 8: explain analyze is your friend

[SQL] little doubt

Shoul I thank the guys who help me? Or to post other message saying ´it worked well etc´? or it will flood the lists?   I´m new(bie) on the lists.   tnx   Eric Anderson Martins MirandaNet Admin @ Via Net SAO

Re: [SQL] discover a toast table name

when i try that i´v got an error ERROR: "pg_toast_26474986" is a system table. call REINDEX under standalone postgres with -O -P options so I kill postmaster and up it standalone. but the reindex command doesn´t have options. and postmaster doesn´t have these ones too. tnx. Eri

Re: [SQL] cast of integer to bool doesn't work (anymore?)

;); > $sth->execute('test', '0'); Ah, thanks, that seems to work, with only minor modifications to our code. Is there any reason why integers are no longer convertable to booleans? -- Eric Veldhuyzen xs4all NSA team pgp0.pgp Description: PGP signature

[SQL] Querying Hierarchical Data

Hi, How do I access hierarchical data under PostgreSQL? Does it have SQL command similar to Oracle's CONNECT BY? Any help is appreciated Eric ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [SQL] Query for filtering records

I'm getting multiple exists index scans instead of nested loops or table scans. What's more, exists clauses are really easy to integrate into my query generation routine. thanks eric ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Query for filtering records

on / intersect since I don't really ever know what columns are going to be in the query. perhaps I should revisit that decision and try to work around it. eric ---(end of broadcast)--- TIP 2: you can get off all lists at once with the

Re: [SQL] Hairy question - transpose columns

unction that could do this too, but I'd tend to just convert the data and be done with it. eric ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Row Locking?

ted to get the contents? (perhaps without doing a table scan to find the oid of the row that I just updated). I can't afford to lock the entire table. eric ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [SQL] Help with SQL

11031 Drew| 30 |104 zombiechick | 3 |159 (4 rows) Thanks for your help! Eric L. Blevins - Original Message - From: "Oliver Elphick" <[EMAIL PROTECTED]> To: "Eric L. Blevins" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: We

[SQL] Help with SQL

I'm new to postgres. I've got 2 SQL statements I would like to combine into one.   I think I need to use a sub select or join I am not sure. Any help would be appreciated!   statement 1: SELECT  uid, count(uid)  FROM triangulated WHERE uid != 'anonymus' AND uid!= 'anonymous' AND uid != '' GRO

Re: [SQL] select question

oth 1 and 3. > Given run 'a' and wafers (3) I should get two rows: foo,bar, since both foo and >bar match 3. > > Is there some neat way to do this in a single query? > select test from T where run='a' and wafers in ('1','3') group

Re: [SQL] Query kill

ts of work. Generally, this is an unconstrained join between my biggest tables, a result that is neither fast nor useful. If I could set a threshold of 1M units for the webapp user, I could trap this sort of thing before they cause quality of service issues. eric --

[SQL] Localization

Hi all Is there a simple way to localize in foreign language error messages without modifying and compiling the sources again ? It should be useful for final users who don't read Shakespeare in the original version ;) Eric GRIMOIS Analyste programmeur SEI - CPAM du Val d

Re: [SQL] Limiting database size

I like the idea of putting it on a hard disk or partition of fixed size and waiting for the DB to simply crash. hahaha "Josh Berkus" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > Mauricio, > > > Hi, is there any way to limit the database size?? > > First, this is a question fo

[SQL] Performance Ideas

view after a vacuum but it does not. Also, the function seems faster in the temporary table, why? Why wouldn't the funciton only evaluate values that match the first 2 criteria (OPEN and ol.orderid = o.orderid)? It's as if the qty_onhand is evaluating ALL records in the orderlines

[SQL] 2 Selects 1 is faster, why?

fundamental change shown above seems to give me the instant response I am looking for. (1) takes about 60 seconds to run and (2) takes 3-5 seconds to run. Thanks, Eric ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]