Re: [SQL] How to encode and decode password in pgsql !!

2001-05-03 Thread Subhramanya Shiva
i could not find chkpass in pgsql datatypes ... it is giving error called : Unable to locate type name chkpass in catalog. what shall i do ?? regards Shiva. > Thus spake Subhramanya Shiva > > how to store password details in a table. in encoded form > > and how to decode it. > > > > in mysql

Re: [SQL] How to encode and decode password in pgsql !!

2001-05-03 Thread Roberto Mello
On Wed, May 02, 2001 at 01:07:57AM +0530, Subhramanya Shiva wrote: > hi all > > how to store password details in a table. in encoded form > and how to decode it. > > in mysql ...we r having encoding and decoding for a password > security ... so how to do in pgsql... I usually do the enc

[SQL] RE: "correct" sorting.

2001-05-03 Thread Joel Burton
On Thu, 3 May 2001, Gerald Gutierrez wrote: > Hi folks, > > say i have a text field with teh values > > 1,2,3,10,20,30,1a,1b,2a,2b > > and i want to sort it so i get, > > 1 > 1a > 1b > 2 > 2a > 2b > 3 > 10 > 20 > 30 > > is there anyway to do that with postgresql ? > below is what actually ha

RE: [SQL] "correct" sorting.

2001-05-03 Thread Gerald Gutierrez
That list looks like an ordering that is custom to your application. The latter sort created by the SQL seems more typical (correct?) to me. I would return the table unsorted, and write the sorting routine in the calling code instead. -Original Message- From: [EMAIL PROTECTED] [mailto

Re: [SQL] '13 months ago'::reltime

2001-05-03 Thread Tom Lane
Type reltime is old and deprecated. Don't use it. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECT

Re: [SQL] How to encode and decode password in pgsql !!

2001-05-03 Thread Bruce Momjian
[ Charset ISO-8859-1 unsupported, converting... ] > D'Arcy, > > > You use the chkpass type that I just commited to the distribution > > (finally.) > > Here is an example of its usage. > > Does that mean that chkpass is part of 7.1, or only the current CVS? > It will appear in 7.1.1, to be rel

Re: [SQL] How to encode and decode password in pgsql !!

2001-05-03 Thread Tom Lane
"Josh Berkus" <[EMAIL PROTECTED]> writes: >> You use the chkpass type that I just commited to the distribution > Does that mean that chkpass is part of 7.1, or only the current CVS? Unless someone rips it out again, it will be part of 7.1.1. I think D'Arcy acted inappropriately in committing a

Re: [SQL] How to encode and decode password in pgsql !!

2001-05-03 Thread Josh Berkus
D'Arcy, > You use the chkpass type that I just commited to the distribution > (finally.) > Here is an example of its usage. Does that mean that chkpass is part of 7.1, or only the current CVS? -Josh __AGLIO DATABASE SOLUTIONS

[SQL] '13 months ago'::reltime

2001-05-03 Thread Albert REINER
Saluton, I do not quite understand the following: , | albert=> select '13 months ago'::reltime; | ?column? | - | 1 year 25 00:00 ago | (1 row) | | albert=> select '13 months ago'::interval; | ?column? | | 1 year 1 mon 00:00 ago |

Re: [SQL] How to encode and decode password in pgsql !!

2001-05-03 Thread D'Arcy J.M. Cain
Thus spake Subhramanya Shiva > how to store password details in a table. in encoded form > and how to decode it. > > in mysql ...we r having encoding and decoding for a password > security ... so how to do in pgsql... You use the chkpass type that I just commited to the distribution (finally.) H

[SQL] How to encode and decode password in pgsql !!

2001-05-03 Thread Subhramanya Shiva
hi all how to store password details in a table. in encoded form and how to decode it. in mysql ...we r having encoding and decoding for a password security ... so how to do in pgsql... regards Shiva. -- Subhramanya Shiva, Programmer Archean InfoTech pvt.Ltd. Hyderabad, India http://www.arche