Thanks. What about auto-analyze? When will they be analyzed by default?
And what actions generally require new analyze?
On 2/15/12, Bruce Momjian wrote:
> On Wed, Feb 15, 2012 at 09:14:34AM -0500, Robert James wrote:
>> What rules of thumb exist for:
>> * How often a table needs
On 2/15/12, Tomas Vondra wrote:
> On 15 Únor 2012, 15:20, Robert James wrote:
>> What parameters should I change to use the server best? What are good
>> starting points or them? What type of performance increase should I
>> see?
...
> But you haven't
> mentione
unctions to
cover all possible type permutations. My question is, can I write a single
function that accepts arbitrary and different types for its three arguments?
I'm using PostgreSQL 9.1.
Thanks, Robert
CREATE OR REPLACE FUNCTION bound(x ANYELEMENT, lo ANYELEMENT, hi ANYELEMENT,
ht behavior would be if
composite types supported defaults, but they don't, never have, and
maybe never will. I had a previous argument about this with Tom, and
lost, though I am not sure that anyone other than Tom thinks that the
current behavior is for the best. But see commits
tor would, but that concept doesn't really exist
in SQL, which is seemingly deliberately quite murky about when values
spring into existence.
Does the SQL standard say anything on this topic?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via p
(sorry for top posting but I'm using a less than sane email client)
I came across SQL Power Architect not long ago and it might be something you
could use.
http://code.google.com/p/power-architect/
I haven't had much time to look at it though.
Regards,
roppert
Från: pgsql-general-ow...@pos
I can run clusterdb -a from the command line to cluster all databases.
After clustering, its recommended to run ANALYZE. But there doesn't
seem to be any way to do this from the command line, and even in SQL,
there doesn't seem to be any way to do this for all databases.
1. What's the recommende
I see how CLUSTER can speed up a range query (eg WHERE val < 30),
because it groups those records in contiguous pages.
What about where I'm only pulling one record back? Eg WHERE user_id =
100. Is there any benefit to a CLUSTER in that case? Is there
anything lost if I CLUSTER on a different ind
Besides the one time spent CLUSTERing, do I loose anything by doing it
for every table? Does a CLUSTER slow anything down?
It would seem to me that a) a CLUSTER should never have worse
performance than a random order b) may have better performance and c)
has the benefits of a VACUUM and REINDEX.
On 5/15/12, Steve Crawford wrote:
> On 05/15/2012 02:02 PM, Robert James wrote:
>> Besides the one time spent CLUSTERing, do I loose anything by doing it
>> for every table? Does a CLUSTER slow anything down?
> Cluster should have better performance but it depends on the
I am trying to get the following program to compile the following program
with Embedded SQL Processor:
#include
main()
{
printf( "I am alive\n" );
#if 0
EXEC SQL CONNECT TO DEFAULT;
#endif
printf( "status is %d\n", sqlca.sqlcode );
}
I am doing this as
ther option for folks is to switch to another operating system thats a bit
more stable *cough*solaris*cough*bsd*cough*
:-)
--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
so you can run your code unmodified.
>
*In theory* :-) There are still a number of shortcomings, so depending on how
large and/or complicated your systems are, it may or may not work for you,
but it's certainly worth a look if you're planning a migration.
--
Robert Treat
C
turns the existing id in place of an INSERT with the new id
returned if not found. I get no errors, but NEW.field remains NULL after
updating the record as shown above. Hopefully I'm doing something wrong?
--
Robert
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ny trigger
functions on the postgres side as well (or at least givec you a good starting
point to adapt it). HTH
--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
While I would agree that these tools can't solve organizational problems, they
do exist:
http://pgdiff.sourceforge.net/
http://apgdiff.sourceforge.net/
http://www.dbsolo.com/
http://sqlmanager.net/en/products/postgresql/dbcomparer
there are others too...
--
Robert Treat
Conjecture:
rst_name FROM (select last_name, first_name from salesmen where
salesmen.id = accounts.sales_id) x
Which is great if you just want to get this done, but sucks if you wanted the
specific syntax from above.
--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
id SERIAL PRIMARY KEY,
>table_changed regclass,
>changed_by VARCHAR,
>changed_when TIMESTAMP WITH TIME ZONE,
> );
>
> and then you have child audit tables for each audited table, each of
> which looks like this:
>
> CREATE TABLE audit_tablename (
>
ten give you added robustness.
Another approach is to partition your data and have several DB servers
which host only part of the data. Whether this is feasible depends of
course on your data and business needs. If you have highly
interconnected data then chances are that this is not an o
that information is a bit out of date.
There's a better write up at
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
Once you go through that and restart, if it's still slow, can you paste
explain analyze from the two different servers?
--
Robert Treat
Conjecture:
rgument much more compelling than anything else
that's been offered up so far.
...Robert
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
'1,2,,4'.
I can't see that there's any way to do this in SQL regardless of how
we define this operation.
...Robert
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, you will get that item back, and if
that item is the empty string, you will now have the empty string. I
think it's better to worry more about the first case because it
applies to any type at all, whereas the latter case ONLY applies in
situations where the empty string is a potentially l
On Wed, Apr 1, 2009 at 5:22 PM, Tom Lane wrote:
> Or we could stick to the current behavior and say "use COALESCE() to
> resolve the ambiguity, if you need to".
If there's no consensus on changing the behavior, it's probably better
to be backward compatible than not
where '' is
> a known value, seems weird to be returning NULL.
*shrug* CASE WHEN blah IS NOT NULL THEN string_to_array(blah, ',') END
More and more I'm leaning toward leaving this alone. No matter how
you define it, the behavior can be changed to whichever alternative
On Thu, Apr 2, 2009 at 12:10 PM, David E. Wheeler wrote:
> On Apr 1, 2009, at 12:19 PM, Robert Haas wrote:
>
>>> my @ints = map { $_ || 0 } split ',', $string;
>>>
>>> This ensures that I get the proper number of records in the example of
>>
other.
ISTM there are three camps.
...Robert
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Apr 2, 2009 at 2:18 PM, Tom Lane wrote:
> Robert Haas writes:
>> On Thu, Apr 2, 2009 at 2:04 PM, Tom Lane wrote:
>>> Right at the moment, if we stick with the historical definition
>>> of the function, *both* camps have to write out their choice of
>>>
On Thu, Apr 2, 2009 at 2:50 PM, Tom Lane wrote:
> Robert Haas writes:
>> On Thu, Apr 2, 2009 at 2:18 PM, Tom Lane wrote:
>>> If there's a camp that actually *wants* a NULL result for this case,
>>> I missed the reasoning.
>
>> So that we don't b
ain lately, but if only 1% of your
rows are going to have data in this column, personally, I'd put it in a
separate table.
--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wednesday 08 April 2009 15:30:28 Ian Mayo wrote:
> On Wed, Apr 8, 2009 at 8:13 PM, Robert Treat
>
> wrote:
> > Maybe I've been reading too much Pascal again lately, but if only 1% of
> > your rows are going to have data in this column, personally, I'd put it
>
On Wednesday 08 April 2009 18:25:25 Ron Mayer wrote:
> Robert Treat wrote:
> > You can be sure that discussion of this topic in this forum will soon be
> > visited by religious zealots, but the short answer is "nulls are bad,
> > mmkay". A slightly longer answer w
"df4.5",
CAST(4.5::numeric as INTEGER) as "cn4.5",
CAST(4.5::float8 as INTEGER) as "cf4.5"
v8.1.5:
rn3.5,rf3.5,dn3.5,df3.5,cn3.5,cf3.5,rn4.5,rf4.5,dn4.5,df4.5,cn4.5,cf4.5
4,4,4,4,4,4,5,4,4,4,5,4
v8.3.7:
rn3.5,rf3.5,dn3.5,df3.5,cn3.5,cf3.5,rn4.5,rf4.5,dn4.5,df4.5,cn4.5,cf4.5
4,3,3,3,4,3,5,4,4,4,5,4
Thanks,
Robert
(GCC) 3.4.2
(mingw-special)
I would like to understand how this difference affects rounding in more
detail so that I may explain caveats to customers.
Thanks,
Robert
On Mon, Apr 20, 2009 at 5:36 PM, Adrian Klaver wrote:
> On Monday 20 April 2009 5:20:47 pm Adrian Klaver wrote:
> > On M
Thanks for the explanation, that's exactly the level of detail I need.
-Robert
On Tue, Apr 21, 2009 at 12:00 PM, Tom Lane wrote:
> Robert Morton writes:
> > Perhaps there are platform differences, since the version I am using was
> > built with Microsoft Visual Studio:
>
Hi,
Thanks in advance for your help.
I have a lot of experience with object-oriented programming and relational
databases, but I'm new to PostgreSQL.
My agency has a contractor that created a PostgreSQL database that he calls
"object-oriented". I noticed that the contractor has more than o
I read the document on array data types. Do they have anything at all to do
with PostgreSQL being "object-oriented"?
Also, these comma-delimited fields make creating reports with our reporting
tool impossible.
>>> Bill Moran 4/27/2009 10:35 AM >>>
In response t
On 2009-05-06 14.34, liuzg4 liuzg4 wrote:
ver 8.4
i create two table with same name named 'testtable'
one is temp table
i select * from testtable
then this table is a public or a temp ???
Temp. To access public use "select * from public.testtable".
"Temporary tables exist in a special
While reading through the docs on Partitioning,
http://www.postgresql.org/docs/current/static/ddl-partitioning.html,
I got to wonder about the example given.
The text in 5.9.2 states, item 1 in the first section, that the master
table will contain no data. This is later confirmed by the example
ot;pgsql-jp" is added to it. The list page is
> http://www.postgresql.jp/PostgreSQL/pgsql-jp.html.
Added, thanks much.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: Hav
afaik the Nerd Ranch guys can go either "fast or
slow" on the course depending on the aptitude of the students... if your
going to be sending multiple people it wouldn't hurt to talk with them.
HTH
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
t;
This has been fixed now, thanks for bringing it up.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscri
d of info
maybe, but they wont be out till summer at the earliest and more likely
the end of the year.
Of course this assumes you can do it at all ;-)
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)--
There's actually a list of recommended books up on techdocs:
http://techdocs.postgresql.org/#books
It could use a little updating, but is still pretty good.
Robert Treat
On Thu, 2005-03-24 at 09:57, Jeff Davis wrote:
> If you are looking for a database theory book, I highly recom
ing servicers have only MySql.
> Thats while I need an information about a hungarian (if you know) or
> non-hungarian free webhosting service with postgreSQL.
>
> Thank you in advance!
>
>
I don't know of any... does anyone else?
Robert Treat
--
You may add a product to the awards at:
http://www.sys-con.com/linux/readerschoice2004/addentry.cfm
Best Regards,
Robert
Joshua D. Drake wrote:
On Mon, 2005-03-28 at 11:03 -0700, Ed L. wrote:
On Thursday March 24 2005 7:07, [EMAIL PROTECTED] wrote:
Thank you
in the order of PHP,
PostgreSQL,plPHP which is the same for all of the other pl's.
You don't need postgresql installed before php any more than you need it
installed for perl (although you do need postgresql installed to compile some
of the perl & php db interfaces, but th
On Mon, 2005-04-04 at 16:17, Tom Lane wrote:
> Robert Treat <[EMAIL PROTECTED]> writes:
> > On Monday 04 April 2005 12:01, Tom Lane wrote:
> >> Peter has pointed out that the problem of circular dependencies is a
> >> showstopper for integrating plPHP.
>
>
On Mon, 2005-04-04 at 17:00, Doug McNaught wrote:
> Robert Treat <[EMAIL PROTECTED]> writes:
>
> > If by "stripped down" you mean without postgresql database support then
> > I'll grant you that, but it is no different than other any other pl
> > wh
On Mon, 2005-04-04 at 17:03, Alvaro Herrera wrote:
> On Mon, Apr 04, 2005 at 04:48:50PM -0400, Robert Treat wrote:
>
> > If by "stripped down" you mean without postgresql database support then
> > I'll grant you that, but it is no different than other any o
e ability to use my$ql... I'd guess that this is because
most php programmers are more familiar with my$ql and my$ql still holds
the edge on the number of third party apps that often get used on free
hosting services like these.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middl
es *NOT* require a dump restore, but due to a bump
> > in the major version number for the client library (libpq), it *WILL*
> > require all client applications to be recompiled at the same time.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware}
ouch upon and then see about
reengineering those particular parts of the schema. The bit by bit approach
should get them to the same end game with stalling development for the next
few months. Make sure to make use of views and stored procedures to help
keep backwards compatibility where
omething like that rather than creating a
surrogate key... so just because they have done that doesn't mean that they
are wrong even if your way is better.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 8: explain analyze is your friend
do savepoints automatically be
released on commit by postgres?
thanks
robert
?
--
Robert
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
NULL and
thats why the boolean type is still in the extended set of sql spec and
not core.
Inceidentally MySQL's boolean is really scary... it's not just than 0 =
false and 1 = true, its 0 = false and (n >= 1) is true. IMHO that
sounds like a recipe for creating subtle bugs.
Robert
the
> > > database, then to the tables, then to the sequences.
> >
> > In this case, why not let 'username' create the database and all its
> > objects so that it will have all privileges on them afterwards without
> > any specific GRANT required?
>
> T
pefully it will
get done. Also the workaround is to create a regular trigger and then do
a check in the function
IF NEW.mycol <> OLD.mycol THEN... it's not quite as spiff but should do
what you want.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
-
27;d like to think it's not optimistic --- but yeah, Thanksgiving-ish is
> a reasonable bet.
Perhaps we should add a couple of lines to the TODO stating that feature
freeze is planned for july 1 and give estimated times for phases to follow?
This could help people to determine how fea
uld be to use slony, which would minimise the down time, but might
not fall into the "without much work" constraint.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 8: explain analyze is your friend
works fine and if I update the pg_hba.conf file
to trust that user, it works. What can cause this? I don't know if I
should post by pg_hba.conf file here, but like I said, nothing has
changed in several months and this problem just appeared today.
--
Robert
---(e
ll late fall at the earliest afaik, so those are probably your best
choices.
Robert Treat
On Friday 03 June 2005 17:23, Bob wrote:
> I think it hits the press in June or July 2005???
>
> On 6/3/05, Brad Nicholson <[EMAIL PROTECTED]> wrote:
> > Gevik babakhani wrote:
> >
you could leave in the
quotes from the previous emails where we say pretty much the exact same thing
only with more detail and actually useful information, it would really be
something.
:-)
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---
actually reference plpgsql,
so if you're interested in that kind of traffic, you might want to subscribe
there.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Anyone else getting duplicate messages? I seem to be getting them
sporadically on different messages on pgsql-general. Seems to have started
sometime Monday morning (estern us time)
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end
ening on
one of my subscribed emails, not the other, which is a little weird...
according to the headers though, this problem is happening further
upstream.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)
On Wednesday 27 July 2005 12:30, Alvaro Herrera wrote:
> On Wed, Jul 27, 2005 at 11:46:05AM -0400, Robert Treat wrote:
> > Seems unlikely unless folks like Tom Lane, Stephan Szabo, and Richard
> > Huxton have unsubscribed and resubscribed lately... Funny thing is it
> > isn
cation needs.
> Combine slony with pgpool and a few scripts and you've got quite a nice
> cluster setup.
>
Can someone point me to the multi-master replication docs for my$ql 4.1? I
agree with Scott, sounds like they are looking for an excuse.
--
Robert Treat
Build A Brighter L
Anyone done it? Is it possible? Currently running the free SQLAnywhere version
included with CQ.
I suspect my hopes will be extinguished shortly :-(
Cheers,
Rob
--
08:11:07 up 26 days, 11:46, 5 users, load average: 2.52, 2.19, 2.20
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004
pgpT
ter
> even if I use oid instead of ctid.
> Inner query works promptly of course.
>
> Any clue?
>
I think using an indexed field would probably be faster for you, especially if
you have a PK on the table. Barring that, make sure you have
vacuumed/analyzed and send us explain analyze
eneral I'd agree with you, but I've seen a couple of (some
would say hackey) use cases where you use the ctid to iterate over the
columns returned in a row in a plpgsql function... :-)
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
-
http://www.bizgres.org/pages.php?pg=downloads
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Anyone know a package that can do this? Perferrably a Unix/Linux
package.
--
Robert
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
seperates the data loading piece from the piece where you promote
the data to live data, plus then the time you have to hold the
transaction open is only for the drop and rename, which will be quite
fast.
the only potential issues would be making sure you dont have FK/View
type issues, but it d
in PostgreSQL..."
>
I think I concur with you on that one Richard... fixed in CVS, will go live on
next site build. Thanks.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hello!
Anyone could explain to me, why cast(3.33 to int) works (from float, I
suppose) but cast('3.33' to int) (from text) does not? And what if I
create a cast for that: is it possibly dangerous?
Regards,
Robert.
---(end of
A. Kretschmer wrote:
am 05.10.2005, um 15:08:33 +0200 mailte Robert Osowiecki folgendes:
Hello!
Anyone could explain to me, why cast(3.33 to int) works (from float, I
suppose) but cast('3.33' to int) (from text) does not? And what if I
create a cast for that: is it possibly
NULL,
tb_ex TEXT,
tb_name VARCHAR(255),
INDEX (tb_page)
);
I couldn't figure out why they weren't specifying type = innodb for the table,
but then figured they must have declared it some place else or something...
but now I see that even that w
, PostgreSQL makes use of some
elements of NTFS which is not supported by win98. To be honest, I believe
you could hack things to get around this, but it's probably not worth the
effort / possible stability issues.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} Postg
nce pg
can't optimize complex queries into the inital query to set up the view.
Not sure if my$ql is any smarter about this, but that's the first thing to
look for if you were to investigate how well it worked.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} Post
e wants to step up to it), why not setup the bug tracker, work with
> > the -www guys on having the 'bug submission' stuff feed into it, and get
> > a
>
> ...
>
> Btw. how do you work with the WWW guys? I _never_ ever got any answer.
>
What did you ask?
plications (think erp and
crm) that my$ql has been targeting to be able to support with 5.0 that would
compete directly with oracle (by way of giving those application vendors
leverage to use my$ql instead of oracle). Part of a future licensing
agreement might be that my
site content / correction are
best sent to pgsql-www or webmaster. If you post elsewhere, we'll probably
see it, but it might take awhile.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)--
me to make sure there are no
schema issues or application issues on the new db. Don't forget to time the
process so you can plan your outage accordingly.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
my guess is that they started reading up as soon
as .org was awarded to a pg based company. I think before that they
probably figured that my$ql, being more popular, was roughly equal if not
better than postgresql, and often confused the two. If there smart enough to
be buying innobase
enterprisedb :-)
> 2) Some sort of FUD campaign on the part of Oracle directed
> specifically at us and not tied to any specific project (fairly likely).
>
look for pointers to lack of benchmarks, patent issues, and great bridge...
those seem to be the most common rehash of fud.
--
R
stalling / compiling. I didn't use the ports
> system though..
>
I can't find the upstream post, but I wonder if some of the articles on
freebsd diary might help? They're a bit old, but I think the general
info still applies: http://www.freebsddiary.org/topics.php#postgre
p and getting it in officially; One concern I had was finding a way to
include information that won't bog down end users with too much data.
(I've noticed large numbers of points tend to do that)
Robert Treat
On Tue, 2005-10-25 at 12:11, Claire McLister wrote:
> Thanks.
>
> I look
st a slew of encodings...I'd start
there.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
I have a field with 'AA-BB-CC-DD' and I want to pull those four values
into an array and then loop through the array inserting records into a
table for each element. Can you someone point me to an example of this
in pl/pgsql?
--
Robert
---(end of
the switch was made. That's how the snowball effect starts, and you can
bet oracle is trying to nip these things in the bud.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 6: explain analyze is your friend
; version).
>
By my math 7.4.2 > 7.3.x so slony should work in the above scenario.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will
I am having a problem gettig a percent via division. Below is the first
part of my trigger function where pct returns 0.00, instead of the
expected 0.50. If I try without dimensions to the numeric variable, I
just get 0. What is the correct way to accomplish the percent?
CREATE OR REPLACE FUNCTION
row)
>
> Btw, apart from the integer problem you are facing, what is
> the whole point of that function (when it finally 'works')?
>
Thanks, of course, can't see for the confusion :(
It is part of a trigger that breaks apart an incoming CSV field by
dashes into an a
he first edition which was very good; it's material is
probably a bit more intermediate level.
Otherwise there is a list of PostgreSQL related books available at
http://www.postgresql.org/docs/books/ which contains links to older books and
books online. HTH.
--
Robert Treat
Build A
owever very strict
> with what license they allow.
>
> Wikipedia commons only allow images licensed as Public Domain or GPL.
That's goofy... the wikipedia "commons" wont accept creative commons licenses?
That's what we've licesed all of the new logos under...
http://www.p
On Fri, 2005-11-11 at 12:01, Andreas Kretschmer wrote:
> Robert Treat <[EMAIL PROTECTED]> schrieb:
> > > Anyway I am open to some good recommendations.
> >
> > I think I would recommend "Beginning Databases with PostgreSQL, 2nd
> > Edition"
> &g
gt; > than some community product called PostgreSQL? (And yes, I suspect
> > there _are_ such people.)
>
> Maybe he is going to call it "Orakle"? :)
>
I was thinking he could call it "my-sql"...
Robert Treat
--
Build A Brighter Lamp :: Linux
the posting of the autonomous transactions and then calling those
inside your functions.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
601 - 700 of 1119 matches
Mail list logo
