Re: [SQL] CHECK constraint on multiple tables

can't you solve it creating a reference between the tables? Ries On Sep 14, 2009, at 8:24 AM, Mario Splivalo wrote: I have two tables, tableA and tableB: CREATE TABLE tableA (idA integer primary key, email character varying unique); CREATE TABLE tableB (idB integer primary key,

Re: [SQL] Query with Parameters and Wildcards

nsitivity (try ILIKE) regards, Ries van Twisk ----- Ries van Twisk tags: Freelance TYPO3 Glassfish JasperReports JasperETL Flex Blaze-DS WebORB PostgreSQL DB-Architect email: r...@van

Re: [SQL] Can we load all database objects in memory?

emory system. Ries On Mar 25, 2009, at 2:20 PM, DM wrote: Hi All, I have a database of 10GB. My Database Server has a RAM of 16GB Is there a way that I can load all the database objects to memory? Thanks for your time and taking a look at this question. Thanks Deepak -- Sent via pgsq

Re: [SQL] "union" vs. left join

n... I never did any real worl testing, but usually I grab a left join before anything else. I would suspect that the planner knows a bit better how to optimize the left join version. Ries -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to you

Re: [SQL] wired behaviour

'Mr Spock'; gives me 857 Why I'm not getting 955 for the last query ? Any idea ? Do you happen to have any NULL values on the field bar?? Ries -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Sequence and nextval problem

#x27;, SOME_INTEGER, true); btw, you should also not expect a specific value from the sequence except that you will always get the next value from the sequence. it's also generally a bad idea to do select max(someid)+1 from table. The whole concept of a sequence is thus much better.

Re: [SQL] Left Join Question

en you can properly use a JOIN instead of a LEFT JOIN, this would make the operation faster I believe. I hope I did explain myself correctly. Ries

Re: [SQL]

On Nov 5, 2008, at 8:42 AM, Hemant Patel wrote: Hello Everyone, I have a array of ids from my search result and now I want to fetch the details from the database. Now IN query is ruined my sort order.So should I go for Union All? IN doesn't ruin your sort order really

Re: [SQL] Problem with pg_connect() in PHP

could be the possible mistake? Anyone to assist me! Best regards, James Kitambara Did you re-start apache after you made the changes to the php.ini file? Ries

Re: [SQL] Implementing ACLs in Pure SQL?

table and an applciation table and a object table Then two MM tables between user and application/object and group and application/object. Then in plpgsql I resolve the correct ACL for a user. Ries -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] partial unique constraint

You should create a functional index here. Ries > -Oorspronkelijk bericht- > Van: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Robert Treat > Verzonden: dinsdag 6 april 2004 16:30 > Aan: [EMAIL PROTECTED] > Onderwerp: [SQL] partial unique constraint > > >

Re: [SQL] is this explain good or bad???

Here are the explain analyze versions: Best regards and thanx in advance Ries explain analyze select count(*) from sq_logfile; NOTICE: QUERY PLAN: Aggregate (cost=35988.07..35988.07 rows=1 width=0) (actual time=71907.64..71907.64 rows=1 loops=1) -> Seq Scan on sq_logfile (cost=0

[SQL] is this explain good or bad???

Hey guys, I'm not sure if this is good or bad but when I want to have a record count of a view it takes at least 75 seconds to complete (PII 1.4Ghz 256Mb RAM). Also when I do a record count of one single table (same table but not joined) it just takes a long time. Firt I want to make sure that the

[SQL] [OT] Frontend recommendations

Hey postgresql gurus, I was just wondering, what kind of frontend do you recommend in 'bills (windows...)' environment? Is it better to use a tool like Qt from trolltech or is it better to use something like Omnis or Access??? What are you opinions best regards, Ries

Re: [SQL] [Fwd: SQL book]

Jodi, get some of Joe Celco books for me they where extreemly usefull. Ries ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [SQL] To use a VIEW or not to use a View.....

. Any hints will be appreciated. best reghards, Ries van Twisk <--- Here you find the output of the explain again: I cannot yet read the output of explain si I'm not sure if the output looks good or bad. echo "VACUUM ANALYZE; EXPLAIN SELECT * FROM full_cablelist WHERE pro

[SQL] To use a VIEW or not to use a View.....

. I ask this because I expect pore performance in feature when the cablelist table holds up to around 20.000 rows. Each query to full_cablelist will return around 1200 rows. best regards, Ries van Twisk -- CABLE LIST CREATE TABLE cablelist ( id SERIAL, cableno

Re: [SQL] RFC: A brief guide to nulls (noarchive)

'. In this way you can use the NOT NULL contsraint so the novice programmer can work with actual values instead of 'forgetting' about the NULLS. This idea can be helpfull for the novice database designer. Just a thought... Ries van Twisk > -Oorspronkelijk bericht

Re: [SQL] [OT] Inventory systems (private)

of a domain table. Anyway so far thangs for the quick responses, I've got something to work on. best regards, Ries van Twisk -Oorspronkelijk bericht- Van: Troy [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 3 december 2002 15:47 Aan: Ries van Twisk CC: [EMAIL PROTECTED] Onderwerp

[SQL] [OT] Inventory systems (private)

w how many attrubutes one item can have (possible between 10 and 20). This can even change in feature opon request. Ries ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] Null not equal to '' (empty)

This is because '' is not equal to NULL '' Means a empty string NULL means a empty set So this: SELECT * FROM tbl WHERE c1 IS NULL; is totally different then: SELECT * FROM tbl WHERE c1=''; Ries -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto

Re: [SQL] Dublicates pairs in a table.

done using a regular user but of course a update needs to be done within a acceptable time so the user does not get annoyed. best regards, Ries van Twisk > -Oorspronkelijk bericht- > Van: Richard Huxton [mailto:[EMAIL PROTECTED]] > Verzonden: maandag 16 september 2002 17:08