Re: [GENERAL] PROBLEM: Function does not exist

Hello Michael, yes, you have right. Solution is cast it to smallint. Thank you for your advice, with best regards, Julian Legeny Thursday, June 23, 2005, 2:48:17 AM, you wrote: MF> On Thu, Jun 23, 2005 at 12:36:50AM +0200, Julian Legeny wrote: >> >> CREATE OR R

[GENERAL] PROBLEM: Function does not exist

Hello, I'm using postgres 8.0.3 under win xp. I have problem to call psql function. I have tables: 1. BF_DOMAIN 2. BF_USER 3. BF_FILTER (this table uses FK from the previous two tables) and function INSERT_BF_FILTER that inserts data to the table BF_FILTER. But when I call

Re: [GENERAL] ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)

Hello, that's what I was looking for. Thanks to all for advices, with best regards, Julian Legeny Tuesday, May 10, 2005, 12:14:38 PM, you wrote: RS> SELECT * FROM MY_TABLE ORDER BY lower(NAME), NAME RS> The second NAME is to ensure that AAA comes before aaa, otherwis

[GENERAL] ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)

BBB CCC aaa bbb ccc But I would like to sort all data as following: NAME --- AAA aaa BBB bbb CCC ccc How can I write sql command (or set up ORDER BY options) for selecting that? Thank you in advance for answer, best regards, Julian

[GENERAL] Select after insert to the unique column

hat SELECT COUNT(*), there is error occured again: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block How can I solve this? Thank you in advance, with best regards, Julian Legeny All th

[GENERAL] VACUUM ANALYZE question - PostgreSQL performance tests

(from a DB client) query VACUUM ANALYZE one more time (during retrieving of pages), the performance is much better. Is there also neccessary to call VACUUM ANALYZE also for getting of better performance for select query? Thank you for your answer, with best regards, Julian Legeny