Ahh, thank you, the definition is actually stored in pg_proc in the
prosrc column.
I have been examining the system tables using my home brewed BiggerSQL
Postgresql Database Browser ( http://homepage.mac.com/levanj/Cocoa ) a
MacOS X utility.
BiggerSQL displays tables in a table format, one row per
Thanks to everyone who helped.
I found the solution just by tooling with the SQL syntax.
FYI, the correct syntax is:
UPDATE destination_table SET dest_column=A FROM
(SELECT src_column as A, src_link_col FROM src_table) AS J
WHERE src_link_col=dst_link_col;
Pete
pw wrote:
Hello,
What is the pr
On Friday 12 March 2004 20:12, Jerry LeVan wrote:
>
> Is it possible to recover the text of a function definition from within
> postgresql?
In psql: \df+ my_func_name
To see how that works, start psql with -E
--
Richard Huxton
Archonet Ltd
---(end of broadcast)-
Hi,
I just upgraded to 7.4.2 today...I have started looking at PL/PGsql
functions
and noticed that the pg_dumpall and pg_dump commands are able to
recover the
text for the function definitions.
I have examined ( I think ) every table in my catalog and have not been
able
to find the text definit
On Fri, Mar 12, 2004 at 09:40:13 -0800,
pw <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> What is the proper syntax for updating a column inone table from
> a column in another?
>
> I have tried this:
>
> UPDATE destination_table FROM source_table SET
> destination_table.column_one = source_table
On Mar 12, 2004, at 12:40 PM, pw wrote:
Hello,
What is the proper syntax for updating a column inone table from
a column in another?
I have tried this:
UPDATE destination_table FROM source_table SET
destination_table.column_one = source_table.column_b WHERE constraint;
update destination_table
On Wed, 2004-03-10 at 18:23, William Yu wrote:
At this time, only Newisys offers a Quad Opteron box and it carries a hefty
premium. (Sun's upcoming 4X machine is a rebadged Newisys machine and
it's possible HP's will be also.)
There are several vendors with quad opterons out there. Off the
Hello,
What is the proper syntax for updating a column inone table from
a column in another?
I have tried this:
UPDATE destination_table FROM source_table SET
destination_table.column_one = source_table.column_b WHERE constraint;
This fails, so I must have the syntax incorrect.
Thanks for any
This has been recently covered in a discussion both on this list and on
Hackers. It is not easy to do, apparently, but it is on the radar.
Check the archives.
Best Wishes,
Chris Travers
On Tuesday 02 March 2004 09:53, you wrote:
> Are there any plans for PostGreSQL to support something like th
On MacOS X 10.3.2 and latest everything I get the following error
during make install.
On 7.4.1 my fix was make and make install without java, then rebuild
and install on
the java stuff.
Looks like I have to do the same again with 7.4.2
--Jerry
mkdir /usr/local/pgsql/share/java
/usr/local/ant
Alle 18:53, giovedì 11 marzo 2004, hai scritto:
> Paolo Tavalazzi <[EMAIL PROTECTED]> writes:
> > [ query plans after updating to 7.4.2 ]
>
> Okay, they're certainly a lot closer than before, so I think I was right
> that you were getting bitten somehow by the pg_statistic alignment
> problem. It
Alle 20:14, giovedì 11 marzo 2004, hai scritto:
> On Thu, Mar 11, 2004 at 09:43:57 +0100,
>
> Paolo Tavalazzi <[EMAIL PROTECTED]> wrote:
> > Alle 19:12, mercoledì 10 marzo 2004, hai scritto:
> > > On Wed, Mar 10, 2004 at 18:33:41 +0100,
> > >
> > > Paolo Tavalazzi <[EMAIL PROTECTED]> wrote:
> >
12 matches
Mail list logo
