Re: [GENERAL] Array, ANY and Regular Expressions

2008-08-24 Thread Stefan 'Kaishakunin' Schumacher
Also sprach Tom Lane ([EMAIL PROTECTED]) > "Stefan 'Kaishakunin' Schumacher" <[EMAIL PROTECTED]> writes: > > I have a table with an array column (tags text[]) which I want to > > select from via ANY and RegExes. > > > SELECT tags from zettelk

[GENERAL] Array, ANY and Regular Expressions

2008-08-23 Thread Stefan &#x27;Kaishakunin' Schumacher
I have a table with an array column (tags text[]) which I want to select from via ANY and RegExes. SELECT tags from zettelkasten where 'Sozialpsychologie' ~* any(tags) order by ident; delivers 7 rows SELECT tags from zettelkasten where 'SoziALPSychologie---FOOBARBAZ' ~* any(tags) order by

Re: [GENERAL] Securing Postgres

2005-10-05 Thread Stefan &#x27;Kaishakunin' Schumacher
Also sprach Stefan 'Kaishakunin' Schumacher ([EMAIL PROTECTED]) > Also sprach L van der Walt ([EMAIL PROTECTED]) > > The big problem is that the administrators works for the client and not > > for me. I don't want the client to reverse engineer my database. &

Re: [GENERAL] Securing Postgres

2005-10-05 Thread Stefan &#x27;Kaishakunin' Schumacher
Also sprach L van der Walt ([EMAIL PROTECTED]) > The big problem is that the administrators works for the client and not > for me. I don't want the client to reverse engineer my database. [...] > About the raw database files, I can use encryption to protect the data. How shall the DBMS acces

Re: [GENERAL] License question

2005-10-04 Thread Stefan &#x27;Kaishakunin' Schumacher
Also sprach Aaron Smith ([EMAIL PROTECTED]) [License questions] PostgreSQL is released under BSD License. This license say (informal, IANAL) Do whatever you want with the code, but keep the author's acknowledgements. BSD licensed software is quite often incorporated into commercial products, li

Re: [GENERAL] GUID for postgreSQL

2005-07-27 Thread Stefan &#x27;Kaishakunin' Schumacher
Also sprach Scott Marlowe ([EMAIL PROTECTED]) > On Wed, 2005-07-27 at 15:57, John DeSoi wrote: > > On Jul 27, 2005, at 4:46 PM, Scott Marlowe wrote: > > > > > So, how can two databases, not currently talking to one another, > > > guarantee that their GUIDs don't collide? using a large randomly > >