[SQL] Selecting different views from a Boolean expression

Hi there, I have a web based reporting system that I am coding. I need to be able to view statistics by the calendar year or the fiscal year depending on what the user selects. My issue is how do I change y select statements to change the column output? Example IncidentJan

[SQL] Shared Buffers

Hi list, It is possible to find out how many of shared buffers a SQL Statement used ? I suppose my server is quite good and i am not using all it can give me. Any sugestion ? ps: My larger table has half million records. Ezequias ---(end of broadcast)

Re: [HACKERS] timestamp subtraction (was Re: [SQL] formatting intervals with to_char)

Do we want to do anything about this for 8.3? --- Jim C. Nasby wrote: > Yes, but if it was '2004-01-02 01:00:00'-'2004-01-01 00:00:00' it should > return 25:00:00, not 1 day 1:00. > > I agree with Tom that this should be ch

[SQL] array_to_string

Hi there, I used the function array_to_string, and I found it ignores NULL values, e.g. array_to_string( 'ARRAY[1,NULL,3]', ',' ) returns '1,3'. The function documentation doesn't explain this case. So please tell me: is it the normal behavior or a bug ? TIA, Sabin -