Re: [SQL] Field or record level encryption / decryption

2009-08-14 Thread Hengky Lie
as i know, there is no way to return MD5 result back to its original value. Is this true or not ? Thanks a lot On Aug 14, 2009, at 11:21 PM, Christopher Browne wrote: hengkyliwand...@gmail.com (Hengky Lie) writes: Anyone know what function i can use to encrypt / decrypt field or record

[SQL] Field or record level encryption / decryption

2009-08-14 Thread Hengky Lie
Hi, Anyone know what function i can use to encrypt / decrypt field or record ? When record saved, it saved in encrypt format. When i need to read data, i just call decrypt function. I am using MS Access 2003 and Postgresql 8.3 Thanks a lot. Regards, Hengky -- Sent via pgsql-sql maili

Re: [SQL] Simple Problem ?

2008-09-16 Thread Hengky Lie
but using query with an updateable result. Any suggestion ? Thanks in advance Guillaume Lelarge wrote: Hengky Lie a écrit : This is the same as what i think but the table has primary key and has no relation to other table. This is the table definition : [...] These query result non

[SQL] Simple Problem ?

2008-09-15 Thread Hengky Lie
Dear friends, I really amazed with this problem and need your help. I run simple query from Query window of PgAdmin3: SELECT * FROM mytable limit 10; and the result are NON UPDATABLE QUERY, while i need the result are updatable. I run the same query from Passthrough SQL in Microsoft Access

Re: [SQL] Pls Hlp: SQL Problem

2008-09-12 Thread Hengky Lie
;NF";"Non Food";3960.00;4200.;240. Thanks for any suggestion. Regards, Hengky Richard Huxton wrote: Hengky Lie wrote: Dear friends, Hello. Quick tip - don't reply to another message when starting a new thread, people will ass

[SQL] Pls Hlp: SQL Problem

2008-09-12 Thread Hengky Lie
Dear friends, I have problem in postgresql  view.  This is the view (Pay attention to the red and blue colours): SELECT tblpenjualan.tanggal, tblpenjualan."operator", tblpenjualan.noinvoice, tblpenjualan.bayar, tblpenjualan.bayarvocher, tblpenjualan.jam, tblpenjualan.id, tblpenjualan.jeniscar

Re: [SQL] Rule Error

2007-10-04 Thread Hengky Lie
+0800 mailte Hengky Lie folgendes: > CREATE RULE "rule1" AS ON INSERT TO "public"."tblmasdbt" > > DO (insert into tblmasgl (KODEGL,NAMAREK) VALUES (new.KODEGL, new.NAMAREK)); > > > > But I always get this error : > > > ERROR: column

[SQL] Rule Error

2007-10-04 Thread Hengky Lie
Dear Friends, I have problem with rule and tried several times to solve it but not yet success. Hope someone can help me. I have 2 tables : tblmasdbt and tblmasgl. I want on every record insertion in tblmasdbt, that record also automatically insert into tblmasdbt. I need only 2 relate

[SQL] Need help with CASE statement in Function

2007-10-03 Thread Hengky Lie
Dear friends, I am a new user to postgreSQL and really need help to solve my "stupid ?" problem. I have created function with 4 arguments like this : CREATE OR REPLACE FUNCTION "public"."fHistoryCard" (begdate date, enddate date, ProductID varchar, storeID varchar) RETURNS SETOF "publi