[SQL] Combining values in a column

2005-04-15 Thread Stephen Quinney
aggregate function like sum? Thanks in advance, Stephen Quinney ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [SQL] colored PL with emacs

2004-08-31 Thread Stephen Quinney
hlighting option in the menu. Just just need: Meta-x sql-mode Meta-x global-font-lock-mode (and possibly select the postgres option in the highlighting bit of the SQL menu that appears if you are using X) I hope that helps, Stephen Quinney ---(end of

Re: [SQL] Converting integer to binary

2004-06-11 Thread Stephen Quinney
> select 6::bit(32); >bit > -- > 0110 > (1 row) That would probably work for me in this case as I am interfacing to postgresql via the Perl DBI layer. With perl reading out that field would give me a string representation. Thanks for the tips,

[SQL] Converting integer to binary

2004-06-10 Thread Stephen Quinney
I guess. If there's a standard way to do it though that would be quite nice. Thanks in advance, Stephen Quinney ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[SQL] Timestamp manipulation

2004-03-31 Thread Stephen Quinney
the timestamp lies. e.g. 2004-04-09 16:00:00+01 The beginning of the week (sunday) is: 2004-04-4 and the end of the week (saturday) is: 2004-04-10 Any suggestions as to how to go about this would be great, thanks in advance. Stephen Quinney ---(end of broadcast