Hi,
I'm doing some planning for storing some xml data and am wondering
what is the maximum amount I could insert with one SQL statement.
For example if I read an xml file off the hard drive and wanted to store
that in a text column what would be the largest file I could insert.
How about a 10 K
which index? could you help me again?
Eric Anderson Martins Miranda
Net Admin @ Via Net SAO
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Eric Anderson Vianet SAO" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 8:50 PM
Subject: Re: [SQL] yet pg_to
On June 17, 2003 12:23 pm, Josh Berkus wrote:
> Personally, I'm not a fan of inherited tables; I think they muddy up
> the relationality of SQL without providing any additional
We actually are doing what the original poster is in the process of
doing; we have an ISP billing system based on postgr
On Wed, 18 Jun 2003, Rudi Starcevic wrote:
> Hi,
>
> I'm doing some planning for storing some xml data and am wondering
> what is the maximum amount I could insert with one SQL statement.
There's no limit to max SQL statement size in postgresql, but
practically, you might want a REALLY big mach
Tm,
> This would work though it's not very scaleable. Our current system makes
> all elements of a service into what we call an 'attribute'. The
> attributes are defined in a table, and attached to each account type,
> and turned on or off, and twiddled with various definitions such as
> term/peri
On Wednesday 18 June 2003 06:20 am, Tm wrote:
> On June 17, 2003 12:23 pm, Josh Berkus wrote:
> > Personally, I'm not a fan of inherited tables; I think they muddy up
> > the relationality of SQL without providing any additional
>
> We actually are doing what the original poster is in the process o
how can i compare two querys' eficiency???
TIA,
--
Lucas Lain
[EMAIL PROTECTED]
#! /Scripting/Manager (??)
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Take a look at EXPLAIN and EXPLAIN ANALYSE:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=sql-explain.html
On Wed, 2003-06-18 at 16:23, Lucas Lain wrote:
> how can i compare two querys' eficiency???
>
> TIA,
--
Rod Taylor <[EMAIL PROTECTED]>
PGP Key: http://www.rbt.ca/rbtpub.
On Tue, 17 Jun 2003 00:42:54 -0400 Tom Lane <[EMAIL PROTECTED]> writes:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > On Mon, 16 Jun 2003, Tony G. Harris wrote:
> >> The problem is, when I call the function, I get:
> >> sql-practice=# select update_pay();
> >> ERROR: pay_cursor: no such class
>
Title: Create rule/trigger
Hi All,
Can we create trigger/rule that specifies :
Do action ‘Y’
When
inserts/updates to any table in the database ‘X’ occurs?
If not, what is the alternate way to do this?
Thx. In advance.
Anagha
I have a field
set up as money and I try to calculate some number and put in this field, but
the number will be 6 demical point and I want to cut it to only 2-4 decimal
point, how can I do it? Thanks
<>
On 16 Jun 2003 at 18:15, Tom Lane wrote:
> This is a straightforward change and would not break pg_dump files,
> since fortunately pg_dump always references the underlying types and
> never refers to anything as FLOAT(p). But I wonder whether it is
> likely to break many existing applications. Th
On Mon, Jun 16, 2003 at 05:02:34PM -0500, Bu, Ning wrote:
> I have a field set up as money and I try to calculate some number
> and put in this field, but the number will be 6 demical point and I
> want to cut it to only 2-4 decimal point, how can I do it? Thanks
round(); eg
select round(foo, 2
--- Rodger Donaldson <[EMAIL PROTECTED]> wrote:
> On Mon, Jun 16, 2003 at 05:02:34PM -0500, Bu, Ning
> wrote:
>
> > I have a field set up as money and I try to
> calculate some number
> > and put in this field, but the number will be 6
> demical point and I
> > want to cut it to only 2-4 decimal p
14 matches
Mail list logo
