Hi all,
First of all, thanks to Josuah to start this usefull and long time
waited project :-)
Oleg Bartunov wrote :
> Can you show us the goals of the PostgreSQL Certification ?
To me, there are two things Id like to be "PostgreSQL Certified":
- individuals
- companies
Id really prefer my co
Hi list,
Can I add an array of object to a record?
For example if I have a class (or type) phone_number:
create type phone_number as(
name char(20),
caption char(50),
ph_num char(25));
and I would like associate several (unknown number, a priori) phone numbers
to a record "persons"
can I create
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of dfx
>Sent: Sunday, 3 February 2008 10:38
>To: pgsql-general@postgresql.org
>Subject: [GENERAL] how to add array of objects to a record
>
>Hi list,
>
>Can I add an array of object to a record?
>
>For exampl
Hello,
>> vladimir konrad wrote:
>>> I think that I understand basic relational theory but
> Clearly, you'll have to revisit that thought.
Usually I have one table per "entity" modelled (and the table holds
fields describing that entity).
E.g. subject would have name fields and date of bir
Argentina presente ;-)
Regards,
gb.-
On Feb 3, 2008 6:49 AM, Jean-Paul Argudo <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> First of all, thanks to Josuah to start this usefull and long time
> waited project :-)
>
> Oleg Bartunov wrote :
> > Can you show us the goals of the PostgreSQL Certification ?
Hi Webb,
Webb Sprague ha scritto:
I'm quite proud, this is my first C extension function ;-)
I'd gladly post the code if it's ok for the list users. It's more or
less 100 lines of code. This approach seems promising...
I would definitely like to see it.
here it goes:
---
On Saturday 02 February 2008 10:39 pm, Sim Zacks wrote:
> "PostgreSQL 8.2.4 on i386-pc-linux-gnu, compiled by GCC
> i386-pc-linux-gnu-gcc (GCC) 4.1.1 (Gentoo 4.1.1)"
>
> I am creating a temporary sequence in a function and it seems like it is
> not going away after the function finishes.
> The fron
I respond myself:
Enrico Sirola ha scritto:
[...]
seems to work). The problem for the code above is that it doesn't work
for vectors longer than 1000 elements or so (try it with 2000 and it
doesn't work). I guess I should manage the "toasting" machinery in some
ways - any suggestion is appre
vladimir konrad wrote:
The system I am developing has to handle "tests" (for rowing athletes):
1. how many meters athlete did in 10 minutes (result is float)
2. how long it took the athlete to do 5 kilo-meters (the result is time)
So it looks that I need table for each of 1 and 2 (because of di
Hello, and thanks
> Are the tests that different that you need to segregate the data?
> I see them both as being the time taken to travel a distance. The
> only difference is whether the time or distance is used to end the
> measurement.
Good point (I have realised this after posting, when I dug
On 03/02/2008 06:39, Sim Zacks wrote:
I call the function once it works, when I call it a second time, it
gives me an error that the sequence already exists. When I restart the
application, I can call the function again.
Are you by any chance connecting via ODBC with connection pooling? If
s
JPA,
Id really prefer my company be certified by the community rather than by
a company, despite the full respect I have in SRA's engagement in
PostgreSQL and that we all know their contributions.
What would it mean for a company to be certified?
--Josh
---(end of br
Hi
I'm pretty new to PostgreSQL, and have encountered a bit of trouble with
functions, namely the return type. Version is 8.0.15.
I have the following table:
note (
id int,
added date,
updated date,
text varchar(1000)
)
and want to define a function that just re
Josh Berkus wrote:
Id really prefer my company be certified by the community rather than by
a company, despite the full respect I have in SRA's engagement in
PostgreSQL and that we all know their contributions.
What would it mean for a company to be certified?
I'd hope it'd mean that I can have
Yes, this is the "normal" way, but I was tempted to investigate the
possibility
to use array (of string) or composite types to avoid to increase the number
of tables
and to simplify stored procedures reducing the number of join.
Thi idea was born following the discussion concerning EAV.
Thank you
vladimir konrad wrote:
Worst case would be another column flagging the test type.
Why do you think this is the worst case?
Bad choice of words - just referring to using the where clause to
extract one particular test - if that is insufficient you can use a test
column to track what test i
On Sun, Feb 03, 2008 at 10:00:04PM +0100, dfx wrote:
> Yes, this is the "normal" way, but I was tempted to investigate the
> possibility to use array (of string) or composite types to avoid to
> increase the number of tables
That is an extremely bad thing to "optimize" for. Add tables as
needed f
Myk wrote:
Hi
I'm pretty new to PostgreSQL, and have encountered a bit of trouble
with functions, namely the return type. Version is 8.0.15.
I have the following table:
note ( id int, added date, updated date, text varchar(1000) )
and want to define a function that just returns the dates and
On Jan 31, 2008 4:40 PM, Guy Rouillier <[EMAIL PROTECTED]> wrote:
> Robert Treat wrote:
>
> > Just so you know, I approached OReally about writing a PostgreSQL Cookbook,
> > and they turned it down. They did offer me some other titles, but those
> > don't
> > seem to have gone anywhere.
>
> As som
On Feb 3, 2008 3:23 PM, brian <[EMAIL PROTECTED]> wrote:
> CREATE TYPE your_type
> AS (
> added CHAR(11) NOT NULL,
> updated CHAR(11) NOT NULL,
> text_col TEXT
> );
>
> CREATE FUNCTION get_note(id INT)
> RETURNS SETOF your_type IMMUTABLE
> AS $$
>
> DECLARE
> your_row your_type%rowtype
On Thu, 31 Jan 2008, [EMAIL PROTECTED] wrote:
I haven't done any tuning as of yet. I'm running with the default
settings produced by initdb.
The default settings are junk and the disk pattern will change once
they're set correctly, so tuning ZFS first and then PostgreSQL is probably
backward
On Sun, 03 Feb 2008 18:23:47 -0500
brian <[EMAIL PROTECTED]> wrote:
> Myk wrote:
> > Hi
> >
> > I'm pretty new to PostgreSQL, and have encountered a bit of trouble
> > with functions, namely the return type. Version is 8.0.15.
> >
> > I have the following table:
> >
> > note ( id int, added dat
Hi All,
I have wanted to create a reverse key index for some time now, and it
seems that an evening of reading and half a day of efforts finally paid off.
This is just a proof of concept, and sure, the bit-reversing technique can
use a native language's power for better results.
I started
Gurjeet Singh wrote:
All's okay, except you should not have declared it IMMUTABLE, because the
results depend on a database query.
From the docs:
IMMUTABLE indicates that the function cannot modify the database and always
returns the same result when given the same argument values; that is, it
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Alvaro Herrera asked:
> Is there an existing Postgres group?
Yes, this one:
http://www.linkedin.com/e/gis/41621/0F3C7A53CCD6
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200802032251
http://biglumber.com/x/web?pk=2529DF6AB8F
I"m not a database expert, but wouldn't
create table attribute (
attribute_id int
attribute text
)
create table value (
value_id int
value text
)
create table attribute_value (
entity_id int
attribute_id int
value_id int
)
give you a lot less pages to load than building a table w
On Sun, 03 Feb 2008 11:28:24 -0800
Ron Mayer <[EMAIL PROTECTED]> wrote:
> Josh Berkus wrote:
> >> Id really prefer my company be certified by the community rather
> >> than by a company, despite the full respect I have in SRA's
> >> engagement in PostgreSQL and that we all know their contributions
Frameworks are over-rated. PHP makes most common tasks simple (not that I'm
really a big PHP fan, but it works pretty well most of the time). Just
follow a few basic XSS protection rules, and you will have few problems.
Filter input elements for HTML, don't put stupid things in cookies that can
28 matches
Mail list logo
