Re: [SQL] Breaking up a query

On 8/10/06, Saad Anis <[EMAIL PROTECTED]> wrote: Hi Guys,A fellow at work has written the SQL below to retrieve some data frommultiple tables. Obviously it is inefficient and unnecessarily complex, andI am trying to break it into 2 or more queries so as to enhance performance. Can you please help m

Re: [SQL] to_dec()

On 8/4/06, Melvin Davidson <[EMAIL PROTECTED]> wrote: I have created a to_dec() function, which is in essence, the opposite of the to_hex() function. Does anybody know how I can submit this function to Postgresql ? See 1.5 on the FAQ: http://www.postgresql.org/docs/faqs.FAQ_DEV.html

Re: [SQL] Undo an update

Hi, Judith, Judith wrote: >Is there a way to undo an update??? I'm sorry, but his is one of those short questions that only have long, complex answers. If this answer is to long / complicated for you, begin from the top, and whenever it get's worse, ask yourself how urgent your problem is,