Dennis writes:
What are your thoughts on the best way to approach this? Break up the
stored proc into ten different stored procs that return ref cursors?
I guess another question here is whether I can return a row type or record
type with (integer, varchar, refcursor) and then make use of the
Am 04.05.2004 18:47 schrieb Rob:
> Martin Knipper wrote:
>>Am 04.05.2004 16:11 schrieb george young:
>>>On Sun, 2 May 2004 02:22:37 +0800
>>>"Muhyiddin A.M Hayat" <[EMAIL PROTECTED]> threw this fish to the penguins:
>>>
I Have below table
id | site_name | point
+---+--
Martin Knipper wrote:
Am 04.05.2004 16:11 schrieb george young:
On Sun, 2 May 2004 02:22:37 +0800
"Muhyiddin A.M Hayat" <[EMAIL PROTECTED]> threw this fish to the penguins:
I Have below table
id | site_name | point
+---+---
1 | Site A|40
2 | Site B|90
3 | Site D
On Tue, May 04, 2004 at 18:10:13 +0200,
Svenne Krap <[EMAIL PROTECTED]> wrote:
>
> In the long run, being correct is usually better than being fast (at the
> point of the implementation), as new hardware easily solves bottlenecks
> for problems not scaling exponentially.
And it isn't even cle
I would definately say solution two.
As you point out yourself, there are only for int4s (propably even
int2s), that is 8 bytes each for the int4 (if I remeber corretly), which
equals something in the 40-50 bytes range for the row w/o index.
For 15m rows, thats not much more than 750 megabytes wi
I thank you for your answer.
The more I think about it, the more I find the second option better. Just one
precision.
All tests are always done, so I always hae all columns filled with a result.
My only trouble was about size and performance. I store only a few byte with a lot of
overhead (#a
Am 04.05.2004 16:11 schrieb george young:
> On Sun, 2 May 2004 02:22:37 +0800
> "Muhyiddin A.M Hayat" <[EMAIL PROTECTED]> threw this fish to the penguins:
>
>>I Have below table
>>
>> id | site_name | point
>>+---+---
>> 1 | Site A|40
>> 2 | Site B|90
>> 3 | Site
Am 04.05.2004 16:37 schrieb Andrew Sullivan:
> On Tue, May 04, 2004 at 09:35:31AM -0400, [EMAIL PROTECTED] wrote:
>
>>create table a (a numeric(18,4));
>>create table b (b varchar(25));
>>insert into a values(12000.43);
>>insert into b select (a.a)::varchar;
>
>
> Which version is that? Here's
On Sat, 1 May 2004, Sebastian Tewes wrote:
> Hello :-)
>
> got a little prob...
>
> so my table
>
> create table warengruppen ( kennung char (1),
> holder int,
> HauptWarenGruppe int,
> BezHWG varchar (50),
>
I would go for the second one. I think the size of the table is not a
problem. You will have just to write the right indexes for easy joins.
OBS: " For one assessment, I'll store 60 rows with only two useful integers
in it" ... why? Better make a "lab_test" table where you have the tab tests
and y
On Tue, May 04, 2004 at 09:35:31AM -0400, [EMAIL PROTECTED] wrote:
> create table a (a numeric(18,4));
> create table b (b varchar(25));
> insert into a values(12000.43);
> insert into b select (a.a)::varchar;
Which version is that? Here's my session:
andrewtest=# create table a (a numeric(18,4)
You say that you're running Suse 8.
You can also start the process with that Yast.
Start Yast2 -> System -> Runlevel Editor-> and then you can select the
runlevel when you want that postgre starts. I start it at runlevel 3.
If you installed postgre it manually you have a little work to do, probabl
On Sun, 2 May 2004 02:22:37 +0800
"Muhyiddin A.M Hayat" <[EMAIL PROTECTED]> threw this fish to the penguins:
> I Have below table
>
> id | site_name | point
> +---+---
> 1 | Site A|40
> 2 | Site B|90
> 3 | Site D|22
> 4 | Site X|98
>
> Wo
hi
how can i typecast a numeric(18,4) value (that i'm extracting from a table)
into a a varchar (which i'll be inserting into another table)
that is:
create table a (a numeric(18,4));
create table b (b varchar(25));
insert into a values(12000.43);
insert into b select (a.a)::varchar;
the above
Dear All,
I Have below table
id | site_name | point+---+--- 1 | Site
A | 40 2 | Site
B | 90 3 | Site
D | 22 4 | Site
X | 98
Would like to calc that Rank for each site, and look like
id | site_name | point |
rank+---+---
hi,
Yudie wrote:
> What is isnumeric function in postgresql?
> I'm using psql version 7.2.2
> thanks
probably somebody write a function called isnumeric for you :) So it
must be a user defined function.
C.
---(end of broadcast)---
TIP 9: the planner
Dear All,
I Have below table
id | site_name | point+---+--- 1 | Site
A | 40 2 | Site
B | 90 3 | Site
D | 22 4 | Site
X | 98
Would like to calc that Rank for each site, and look like
id | site_name | point |
rank+---+-
Hello :-)
got a little prob...
so my table
create table warengruppen ( kennung char
(1),
holder
int,
HauptWarenGruppe
int,
BezHWG varchar
(50),
WarenGruppe
int,
Hi Kent,
Did you have a look at Bacula (www.bacula.org) or at Amanda? They store
the catalog containing what they did in a relational database. Bacula
now also works with Postgresql. It still needs to be optimized for
speed, but it works well. It is possible to backup Linux, Solaris, BSD
and Wi
All,
I have an data-driven web application with Java and PostgreSQL. We have
a few tables which hold quite large amount of data. Therefore we put
indexing (B-tree) on them to make query faster. In addition, we are also
doing data synchronization on these tables with another microsoft FoxPro
appl
Hello,
I would like an advise on the following problem :
I have a table of patients.
Each patient can make different biological assessments.
Each assessment is always decomposed into different laboratory tests.
A laboratory test is made of a test number and two values coming from analysers.
Th
Hi,
Thanks for your fast response. But I'm afraid I stated some things unclear.
> >>The data consists of XML-records, with a lot of XML-fields. I want to
> >>store
> >>the XML as it is, so taking the information from the XML-records and then
> >>storing it in a different-from-XML-format is not a
hi,
Marco Lazzeri wrote:
Il gio, 2004-04-29 alle 19:56, Rod Taylor ha scritto:
On Thu, 2004-04-29 at 13:37, Marco Lazzeri wrote:
Hi all.
I have to check if a value is in an array.
I've got a date array in a table and I would like to perform queries
like:
SELECT * FROM table WHERE date IN dates_arra
23 matches
Mail list logo
