In its most basic form a great tool would just start as a pl/pgsql or
pl/perl function that could be used to call a table and have it output
a batch of records to an editable html form or a colored pdf for nice
reports. There would need to be some kind of interface for Apaché of
course.
A
On 2/23/08, dvanatta <[EMAIL PROTECTED]> wrote:
> How should this function be written?
Define output parameters in the function and return SETOF RECORD, e.g.:
--- SQL ---
CREATE OR REPLACE FUNCTION
GET_FOO1(BAR INT, OUT BAZ INT, OUT ZAB INT)
RETURNS SETOF RECORD AS
$BODY$
SELECT $1, $1;
$BODY$
LA
>From the 8.3.0 INSTALL file:
| Upgrading
|
| 1. If making a backup, make sure that your database is being updated.
Ouch. Revert to the language in 8.2, perhaps:
1. Make sure that your database is not updated during or after the backup.
---(end of broadcast)
I'm new to PostgreSQL, moving over from SQL Server and stored procs to
PostgreSQL 8.3 and it's functions and having some difficulty. With SQL
Server I didn't have to define types and return those types from stored
procs which was convenient. I came across Return Query but can't find much
info on
On Feb 15, 2008, at 1:43 PM, Scott Marlowe wrote:
Generally speaking, I tend towards using the real value as the key and
foreign key in lookup tables, but occasionally using an artificial
numeric key is a better choice.
Something to consider here... any table that will have either a lot
of r
On Feb 21, 2008, at 4:08 AM, Alexey Nalbat wrote:
I'd like to use ORDER BY in any specified order and LIMIT, OFFSET
for paging query results.
The query is FULL OUTER JOIN of two tables by field id. I think the
results of Merge Full Join
to be ordered by some "combined id". And there is no need
VTD-XML 2.3 is now released. To download the latest version please visit
http://sourceforge.net/project/showfiles.php?group_id=110612&package_id=120172.
Below is a list of new features and enhancements in this version.
a.. VTDException is now introduced as the root class for all other
VTD-XML's
Dear all,
A new version (1.5) of Benetl has been released.
It is supporting postgreSQL 8.3.x and is better supporting english locale
for floats.
It is also now possible to choose to write datas every x lines.
Thanks for your interest.
Regards,
--
Benoît Carpentier
www.benetl.net
Founder of Be
I am trying to install version 8.3 on windows 2000. I created a Local account
named "postgres" and granted it "Log on as a service" and "Log on
locally" rights as described here
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html#3.3
But when I get to the "Install as Servi
2008/2/22, blackwater dev <[EMAIL PROTECTED]>:
> I have a query that is driving me nuts. In one table we have data that is
> split between two columns and I'm trying to pull in all values from another
> table where that column is represented by one piece of data. Also, all the
> info in column2 i
Em Friday 22 February 2008 13:10:20 Justin escreveu:
> I'm not after small code i'm after maintainable code where the date
> range for this report would be always changing. So if i can get it to
> one select statement i would on have to pass in some variables and it
> would create the moving avera
On Fri, Feb 22, 2008 at 8:12 PM, Greg Stark <[EMAIL PROTECTED]> wrote:
You could use hashtext() which is Postgres's internal hash function.
Awesome!
> There's some possibility it could change in future versions of Postgres
> though.
I can live with that, especially if all that changes is the
On Fri, Feb 22, 2008 at 6:51 PM, Steve Atkins <[EMAIL PROTECTED]> wrote:
>
> On Feb 22, 2008, at 3:40 PM, Kynn Jones wrote:
>
> > Hi. Suppose I have a database that contains a "meta table" that
> > holds the names of other the tables in the database, keyed by human-
> > readable but longish strin
As I understand it, the way that BASIS does phrase searching is based on first
parsing the base text to "context units" (sentences and/or paragraphs) and
then calculating position for tokens within those context units.
That is, a token might have position 3 in context unit 4. All of this is
sto
On Sat, 23 Feb 2008, Stephen Davies wrote:
As it turns out, all I needed was in the doco but the key element - the first
config arg to ts_headline - was not in any of the examples so I missed it.
aha, Original one were based on default
configuration, but then concept was changed, but the exam
15 matches
Mail list logo
