On 8/1/06, Daniel Joo <[EMAIL PROTECTED]> wrote:
Hi all,
Is there a way to view the list of all tables from python (or any other
languages for that matter) DB-API? What I'm looking for is a command
similar to the meta-command '\d' that works with the psql client.
Thanks very much!
Dan
On 7/21/06, Kevin Nikiforuk <[EMAIL PROTECTED]> wrote:
So now that I've got my loops working, on to my next newbie question. I've
created my function and in it, I want to loop through the results of a select
and for each value of my loop counter, I want to create a new table, but I
can't figu
On 7/8/06, T E Schmitz <[EMAIL PROTECTED]> wrote:
Is regexp_replace a new feature?
I am running v 7.4.
Given the patch history:
http://archives.postgresql.org/pgsql-patches/2004-07/msg00471.php
http://archives.postgresql.org/pgsql-patches/2005-06/msg00515.php
http://archives.postgresql.org/pgs
On 7/7/06, T E Schmitz <[EMAIL PROTECTED]> wrote:
Sorry, but that would also capture something like
10-30-59mm
The pattern describes either a single length (120 millimeters) or a
range (30 to 70 millimetres), hence:
\\d+(-\\d+)?mm
The ? quantifier refers to the combination of '-' and digits an
On 7/7/06, T E Schmitz <[EMAIL PROTECTED]> wrote:
But that takes me to the next problem:
For the sake of the example I simplified the regular pattern.
In reality, BASE_NAME might be:
28mm
28-70mm
So the reg. expr. requires brackets:
substring (NAME, '^(\\d+(-\\d+)?mm)' ) as BASE_NAME
Actuall
On 7/7/06, T E Schmitz <[EMAIL PROTECTED]> wrote:
I would like to split the contents of a column using substring with a
regular expression:
SELECT
substring (NAME, '^\\d+mm') as BASE_NAME,
substring (NAME, ??? ) as SUFFIX
FROM MODEL
The column contains something like
"150mm LD AD Asp XR Mac
On 7/7/06, Phillip Smith <[EMAIL PROTECTED]> wrote:
Hi again,
G'day (it's 03:21 on a friday here).
Same SELECT query as before, different area of it… I have a function that
calculates the recommended purchase order quantity for a stock item based
off various other values and functions:
pqty(
On 7/5/06, Keith Worthington <[EMAIL PROTECTED]> wrote:
Hi All,
I just finished writing a query that groups data based on the week number.
SELECT EXTRACT(week FROM col_a) AS week_number,
sum(col_b) AS col_b_total
FROM foo
WHERE foobar
GROUP BY EXTRACT(week FROM col_a)
ORDER BY
Thanks for the quick response. We will be using bytea from now on. :-)
- Leon
Tom Lane wrote:
[EMAIL PROTECTED] writes:
Hi, I'd like to know what the official recommendation is on which binary
datatype to use for common small-binary size use.
If bytea will work for you,
, the data is far less than a gigabyte in size. Is it
strongly recommended by the postgresql community to store things like this
in bytea format as of 8.0?
Thanks,
Leon Torres
[EMAIL PROTECTED]
Open Source Strategies
http://opensourcestrategies.com
---(end of
> I wondered if anyone could answer the following question:
Thanks for your responses, I think I'll just add the extra column in as
Greg suggests. (BTW: I mean "unnecessary *denormalization*" which I hope
is less odd!).
Leon...
--
Apple 4 1
But since (in my intended table) most rows will have col_count = 1, this
seems like unnecessary normalization (and semantically "wrong").
Thanks in advance for any help,
Leon Stringer
---(end of broadcast)---
TIP 3:
quot;)); //GBK、GB2312、BIG5、UTF8
//Input:
InputStream fileIn = new FileInputStream(inputFileName);
int i = fileIn.read(buff);
String data = new String(buff,"UTF8");
Best regards.
leon
- Original Message -
From: "Kurt Ov
user
perporty is missing. It is mandoatory".
netstat | grep postgres |wc -l
The connection number is 278
lsof -i :5432 | wc -l
60
How can I solute this problem?
Is there bug in postgresql's jdbc?
Could you give me help?
Best regards
leon
he UI(jsp)
would report "ieSorry,too many clientslg" .The exception is
SQLException.
I must restart tomcat or postgresql I can continue to running
my UI.
May this problem be soluted?
Best regards.
leon
2003-07-29
15 matches
Mail list logo
