On Fri, May 26, 2006 at 09:08:20AM -0500, Bruno Wolff III wrote:
>
> Rollbacks will not reset sequence values. Use setval to do that.
No, what I posted was the CREATE SEQUENCE after the BEGIN. ROLLBACK
gets rid of the sequence. The next time you create the same
sequence, therefore, it also star
On Fri, May 26, 2006 at 06:50:37 -0400,
Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> On Fri, May 26, 2006 at 05:11:26PM +0700, andi wrote:
> > select rank() over(order by testeridpk ) as rank , * from tester;
> >
> > I get the result is like this,
> >
> >
> > RANK TESTERIDPK TESTER_NA
Penchalaiah P. wrote:
hi sir
how to use encryption to password in postgresql with examples
It depends on what you're trying to achieve - password protection,
concealing data, encrypting a connection.
The md5() function is built-in, and may be suitable for password
protection on a simple we
On Fri, May 26, 2006 at 04:01:47PM +0530, Penchalaiah P. wrote:
> hi sir
>
>
>
> how to use encryption to password in postgresql with examples
I guess you want to read this:
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html
?
A
--
Andrew Sullivan | [EMAIL PROTECTE
On Fri, May 26, 2006 at 05:11:26PM +0700, andi wrote:
> select rank() over(order by testeridpk ) as rank , * from tester;
>
> I get the result is like this,
>
>
> RANK TESTERIDPK TESTER_NAME
>
> 1 10TESSS
>
> 2 90NAMAAA
>
> 3 100
hi sir
how to use encryption to password in postgresql with examples
Thanks & Regards
Penchal reddy | Software Engineer
Infinite Computer Solutions | Exciting Times…Infinite Possibilities...
SEI-CMMI level 5 | ISO 9001:2000
IT SERVICES |
BPO
When I use this syntax
select * from TESTER;
I got
TESTERIDPK TESTER_NAME
10 TE
90 NAM
100 U
In ms sql server 2005 I use this
select rank()
over(order
by testeridpk ) as rank , *
from tester;
I get the result is like
this,
RAN
