[SQL] CREATE TEMPORARY TABLE ON COMMIT DROP

ON at character 60. Thanks in advance for you answers. Luis Sousa ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [SQL] Problem in age on a dates interval

Yes, that's a much more clever solution than the one I used. Thanks Best regards, Luis Sousa Alexander M. Pravking wrote: On Mon, Jul 19, 2004 at 10:00:50AM +0100, Luis Sousa wrote: I worked around this problem returning the difference between the two dates, using extract doy from both. Anyway

Re: [SQL] Problem in age on a dates interval

I worked around this problem returning the difference between the two dates, using extract doy from both. Anyway, this will cause a bug on my code when changing the year. Any ideas? Best regards, Luis Sousa Tom Lane wrote: Theodore Petrosky [EMAIL PROTECTED] writes: wow at first I thought

[SQL] Problem in age on a dates interval

, and this interval added to the initial date gives the correct result!! Best regards, Luis Sousa ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[SQL] Setuid functions

Hi all, How can I set a function as setuid ? I take a look at the documetation, on Reference Manual and the only reference I saw to it was on SET SESSION AUTHORIZATION. Thanks in advance. Luis Sousa ---(end of broadcast)--- TIP 4: Don't 'kill -9

Re: [SQL] plpgsql recursion

Can you post the recursion function that you use on this case to get out the information from the table ? Thanks, Luis Sousa Stefano Vita Finzi wrote: Greetings! I have a table like: node parent 1 2 2 3 3 4 Since i traverse this table with a recursive function, i want

Re: [SQL] SQL query help!

Tell me what did you try with limit and group by. Where's IN, why don't you use EXISTS instead. It runs much master ! Regards, Luis Sousa Arcadius A. wrote: Hello! I hope that someone here could help. I'm using PostgreSQL7.1.3 I have 3 tables in my DB: the tables are defined

Re: [SQL] Problems invoking psql. Help please.

agree with Tom Lane. Probably is the best thing to do. When you install all it over, in theory, all the problems will solve by them selfs. Luis Sousa smime.p7s Description: S/MIME Cryptographic Signature

Re: [SQL] Problems invoking psql. Help please.

Hi there, I'm using debian woody. If you post your configuration files that are in /etc/postgresql/ maybe i can help you. Regards, Luis Sousa Hugh Esco wrote: Hey folks: I am able to consistently start and stop the postgreSQL server and to access it across our office network with pgAdmin II

Re: [SQL] Permission on insert rules

Is that the only way to do it ? Luis Sousa smime.p7s Description: S/MIME Cryptographic Signature

[SQL] Permission on insert rules

got permission denied on those tables. The idea was to create a layer, with the views, giving to that user permission on views to insert and update, and not to tables. Is this possible ? Thanks in advance. Luis Sousa smime.p7s Description: S/MIME Cryptographic Signature

[SQL] Executing RECORD's inside a FUNCTION

Hello I have a function with a field record named 'starting'. Now I want to use starting in a query. Is it possible ? I use it with a simple join inside the query a I got the message that table starting is not defined !!! Best Regards Luis Sousa ---(end of broadcast

[SQL] Hidden Select

fields in the view so it could be possible to restrict that data Best Regards Luis Sousa ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[SQL] Rule ON DELETE, to perform to DELETE querys !

this Thanks Luis Sousa ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster