[SQL] Dividing results from two tables with different time frames

I hope I can explain this clearly.  I have two queries I’m running in a report.   The first one is:   select   dr.store_id,     store.suffix,     store.sort_id,    

[SQL] nested select within a DISTINCT block

Hi, here i have a problem with this task... I have a table "cancellation" which stores cancelled bookings and details of charges etc and a table "bookings" which stores details of bookings, for example: cancellation(cancellation_id, booking_id, charge) booking(booking_id, customer_id, product_pa

Re: [SQL] hi i am gettin error when i am deleting a function from my pgadmin

On 9/11/06, Penchalaiah P. <[EMAIL PROTECTED]> wrote: Hi good morning to all…. I created some functions in my pgadmin… when I am deleting those functions from that pgadmin its giving error…i.e   An ERROR  has occurred   ERROR:function function_name1(character varying, characte