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

2006-09-16 Thread Aaron Bono
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, character

[SQL] nested select within a DISTINCT block

2006-09-16 Thread zqzuk
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,

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

2006-09-16 Thread Becky Hoff
I hope I can explain this clearly. I have two queries Im running in a report. The first one is: select dr.store_id, store.suffix, store.sort_id, year as data_year, (dr.layaway_starting_balance + dr.layaway_net_change) as layaway_balance, (dr.loan_starting_balance +