Re: [SQL] Foreign Unique Constraint

Am Mittwoch, 28. März 2007 00:17 schrieb Phillip Smith: > Perhaps this...? It would work, but depending how many rows are in the > table, it could become incredibly slow. > > ALTER TABLE table1 ADD CHECK (extension NOT IN (SELECT extension FROM > table2)); Subqueries are not allowed in check const

Re: [SQL] Regular Expressions [progress]

Richards and List, Now I find out the 'similar to' statement where I can do such search, but I must still parse all substrings. Here is my stage: Select * from myAddressTable where address similar to ('%(ELMO|ST.|258)%') But I still need to Separete all strings. Could someone help me in thi

Re: [SQL] Foreign Unique Constraint

Subqueries are not allowed in check constraints. I hadn't tried this yet but i'm sure i would have figured this out quickly then =) Thanks, Jon ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [SQL] Regular Expressions [progress]

> Select * from myAddressTable where address similar to ('%(ELMO|ST.|258)%') > > But I still need to Separete all strings. What is it that you are trying to achieve? What string would you like to seperate? Regards, Richard Broersma Jr. ---(end of broadcast)

[SQL] union with count?

Hi dudes, i have the following question i have 2 tables with the same format, and i want to know if is there a possibility of using some sort of count(*) for achieving this result: select a from table1 where (condition) union select a from table2 where (condition), count(a) group by a The idea

Re: [SQL] union with count?

am Wed, dem 28.03.2007, um 11:04:29 -0300 mailte Gerardo Herzig folgendes: > Hi dudes, i have the following question > i have 2 tables with the same format, and i want to know if is there a > possibility of using some sort of count(*) for achieving this result: > select a from table1 where (condi

Re: [SQL] union with count?

--- Gerardo Herzig <[EMAIL PROTECTED]> wrote: > Hi dudes, i have the following question > i have 2 tables with the same format, and i want to know if is there a > possibility of using some sort of count(*) for achieving this result: > select a from table1 where (condition) union select a from ta

Re: [SQL] union with count?

Thanks! But now i have another problem related with count(): select page_id, word, word_position, count(page_id) from (select * from search_word('word1', 'table1') union search_word('word2', 'table2')) foo group by page_id; and gives me "foo.word must appear in GROUP clause or be used in an

[SQL] Rules with sequence columns

I have the following situation that I would appreciate your input on: I have a table with a column that I use to uniquely identify its rows. The table also has a rule on insert that stores the row identifier into another table for reference at some other point. The table is defined as CREATE

Re: [SQL] Rules with sequence columns

Ray Madigan <[EMAIL PROTECTED]> writes: > Does anyone have any suggestion? Use a trigger to propagate the data to the other table. You can't make this work reliably with a rule, because rules are macros and hence inherently subject to double-evaluation problems when dealing with volatile function

Re: [SQL] union with count?

Gerardo Herzig <[EMAIL PROTECTED]> schrieb: > Thanks! But now i have another problem related with count(): > > select page_id, word, word_position, count(page_id) from (select * from > search_word('word1', 'table1') union search_word('word2', 'table2')) foo > group by page_id; > > and gives me

[SQL] How too select different views using a IF/THEN/ELSE procedure ?

Below is a select statement that select incidents by month. I need a function or a method to select differents views that will show the Month columns is a different order. Say Apr - Mar for a fiscal year. I need to do something like an if/then/else statement that selects the correct view to us

[SQL] Track query status

Hi all, I have ran a update query on a dataset which has about 48 million records and the query is already running for the third dayim so tempted to the kill this query nowis there a way to know if the query is running?? here is the query i've ran UPDATE ma SET av=to_tsvector('default',c

Re: [SQL] Track query status

On Wed, Mar 28, 2007 at 04:59:24PM -0400, Sumeet wrote: > Hi all, > > I have ran a update query on a dataset which has about 48 million records > and the query is already running for the third dayim so tempted to the > kill this query nowis there a way to know if the query is running?? > h

Re: [SQL] Foreign Unique Constraint

Is that an 8.2 thing? I'm sure I've done it before, probably in 8.1 Maybe it was a trigger I did it in - I can't remember what I had for breakfast, let alone a slow sub-query I did months ago :P Cheers, ~p -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

[SQL] SELECT INSTEAD

Hi all, I'm trying to create a view of the query below, but I'm being barked at about "rules on SELECT must have action INSTEAD SELECT". I don't have any rules in my database, and I don't know how this query is trying to create one. The query does work if I just run it interactively. Any help w

Re: [SQL] SELECT INSTEAD

On Thu, Mar 29, 2007 at 03:35:52PM +1000, Phillip Smith wrote: > I'm trying to create a view of the query below, but I'm being barked at > about "rules on SELECT must have action INSTEAD SELECT". I don't have any > rules in my database, and I don't know how this query is trying to create > one. ht

Re: [SQL] SELECT INSTEAD

Thanks Michael - The 2 queries (sorry, should have said transaction) are a simple way to identify duplicates in our mailing list. If there are triplicates, the first query will return 6 rows into the temp table, 1 for each of the 2 duplicates), but I only need to show the 3 triplicates once each, n

Re: [SQL] SELECT INSTEAD

Phillip Smith wrote: I'm trying to create a view of the query below, but I'm being barked at about "rules on SELECT must have action INSTEAD SELECT". I don't have any rules in my database, and I don't know how this query is trying to create one. The query does work if I just run it interactively