Re: [SQL] How Do I Hide Trigger ??

2003-04-14 Thread Christoph Haller
> > Dear Milist,=20 > For the security reason, i'd like=20 > to Hide or Encrypting some Function, > triggers or procedure on tables pg_proc,=20 > So If I have many user on my database, > there will be one user could see the > "prosrc" on pg_proc or could do select=20 > the pg_proc without encrypte

Re: [SQL] fast case-insensitive sort

2003-04-14 Thread Tom Lane
"Sigi Jekabsons" <[EMAIL PROTECTED]> writes: > 'surname' is varchar(255), indexed in the manner shown on my > previous post. You're quite right, though, I just tried indexing and > sorting by a column of type text and that worked just fine, it used the > index in the order by. Why is that? I wou