[SQL] anal about my syntax

Hello All   I was looking at this plpgsql function:  FOR rec IN EXECUTE''select count(person_id) as total from person where person_email like '' || $1 || ''% and person_id IN (select cp.person_id from cluster_person cp, cluster c where cp.cluster_id = c.cluster_id and c.c_id = '' ||

[SQL] sql question after upgrade

Hi just upgraded to 7.3.2 and imported my db schema with no probs! Just wondering... why VOLATILE is being appended to my functions - can anyone ansewer me what this means? - should i be using joins instead, does this make a difference? If so an example of this would be much appreciated!! C

[SQL] indexing

Hi all,   I've been doing a little reading on indexing in prelude to indexing my db. I have the following to ask:   if I had three tables for a many to many relationship say A, B, AND C B being the lookup. B being a huge 50k rows plus column and made just two forigen keys(b.a_id,b.c_id). is i

[SQL] a change of query

select distinct cp.person_id from cluster_person cp, cluster c where cp.cluster_id = c.cluster_id and c.c_id = 1 can this query be changed to give just the row count?( of the distinct rows ) yes: i am aware of count() but this wont count the distinct rows - I can however achive this with an n