Re: [SQL] How to secure PostgreSQL Data for distribute?

2005-08-17 Thread Pascual De Ruvo
On 8/17/05, Premsun Choltanwanich <[EMAIL PROTECTED]> wrote: > > Dear All, > > I need to distribute my application that use PostgreSQL as database to > my customer. But I still have some questions in my mind on database > security. I understand that everybody who get my application data

Re: [SQL] Counting Row

2005-07-24 Thread Pascual De Ruvo
I understand you need to count of tickets smaller than $recid given [CONDITION], in that case: $sql="select count(*) from [MYTABLE] where [CONDITION] and ticketnumber <=" . $recid  ; On 7/21/05, Ricky Sutanto <[EMAIL PROTECTED]> wrote:   Hi postgre people. Can anybody help to fix per

Re: [SQL] Using subselects as joins in POstgeSQL (possible?, examples)

2005-07-22 Thread Pascual De Ruvo
On 7/22/05, frank church <[EMAIL PROTECTED]> wrote: Is it possible to use subselects as joins in PostgreSQL. Absolutely.  select * from (select * from table1) as a, (select * from table2) as b where a.a = b.b