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 happens.
jeff=> select * from foo order by var1;
var1
--
1
10
1a
1b
2
20
2a
http://www.brasileiro.net/postgres/
Jie LIANG
St. Bernard Software
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
[EMAIL PROTECTED]
www.stbernard.com
www.ipinc.com
On Wed, 2 May 2001, Adam Walczykiewicz wrote:
> Is there available some more examples of writin
did you get this error when you tried to :
createlang plperl template1?
me too!
then i did this
find /usr -name libperl.so
/usr/lib/perl5/5.6.0/i386-linux/CORE/libperl.so
and then added
that dir {/usr/lib/perl5/5.6.0/i386-linux/CORE/}
to the /etc/ld.so.conf
ldconfig
and vroom it all went t
Cannot build PL/Perl because libperl is not a shared library.
I'v got this error when I tried to compile PL/Perl.
I have SuSE Linux 7.0 , have I get a libperl.so library , and put it in
/usr /lib ...
Thanks for any help
Adam
--
---(end of broadcast)---
Is there available some more examples of writing functions in PL/Perl ?
In standard documentation there is only just 2 examples.
Thanks in advance for any help.
Adam
--
---(end of broadcast)---
TIP 2: you can get off all lists at once with
Title: RE: [SQL] List Concatination [warning]
A word of warning for the newbies...
*Don't* create a function called textcat. You *will* be sorry. There's
already a textcat builtin and you kinda need it for || and whatnot.
(Yes, I found out the hard way...)
There might be a better way to
I understand that an UPDATE is done using "old" values of the variables
involved so that we can write
T(n + 1) = U(T(n))
where T(n) and T(n + 1) are the values of the table before and after
update U.
Thanks for all who pointed this out.
Just as a matter of interest, I want to point out that t
Hi all. We have a table called DeckEJB with the follow structure and
associates indices as indicated below. Our application makes use of this
table by doing INSERTs into it, and then after every 741 inserts, one
DELETE. We are not SELECTing from the table in our test, though in
production use SEL
