and store the text-part and the numeric-part separately,
but first i would prefer a non-alter-table solution :)
currently my only idea is to find the longest entry, check how many of
them are, and then find the ones whose numeric part starts with "9"
etc... ugly, but should work.
x27;g'
4, 16, 'h'
5, 9, 'Unknown'
5, 16, 'Unknown'
6, 9, 'Unknown'
6, 16, 'Unknown'
7, 9, 'Unknown'
7, 16, 'Unknown'
8, 9, 'i'
8, 16, 'j'
9, 9, 'Unknown
riously consider upgrading to 7.4.1. 7.2 is ancient and really
> shouldn't be used anymore.
Mutch as I would like to, this is not an option.
Thanks for your help,
JJ
On Fri, Mar 05, 2004 at 08:39:12AM -0800, Jonathan M. Gardner wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SH
Hi!
Why don't you use pg_restore. You can set the order of restoring with
parameters.
(I haven't tried)
By,
Gabor
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Együd Csaba
Sent: Friday, July 09, 2004 7:15 AM
To: 'SZŰCS Gábor'; [EMAI
re-checked; it's WITHOUT in both version, but it's irrelevant if you give
the full spec. Well, then maybe it was a difference between 7.2 and 7.3, but
again, it's irrelevant in your case. Have you tried the typecast?
G.
%--- cut here ---%
\end
- Origina
