Look at your output using a binary viewer of some type. The font you
are using in whatever client you are using to connect to the database
may not have the character you are trying to display - a common
default is to use a ? in place of the unrenderable character. In
other words the character m
Hi,
I'll try to switch from Oracle to postgres for some small applications.
Is it possible to build functions like Oracle's nvl or decode with
pgplsql?
How can I make a function like nvl that works for every datatype?
Best regards,
Christian
Try coalesce. The syntax is the same as nvl.
Jeff
-
Done ... am regenerating all the archives right now:
# To: jm ( at ) poure ( dot ) com
On Mon, 25 Aug 2003, Christoph Dalitz wrote:
> Hello Marc,
>
> On Wed, 18 Jun 2003 17:30:52 -0300 (ADT)
> The Hermit Hacker <[EMAIL PROTECTED]> wrote:
> >
> > as I've asked in the past, if you know of a
> >
On Thu, 21 Aug 2003, Tom Lane wrote:
> We have had some people looking at improved buffer management
> algorithms; LRU-2 or something smarter would help. I dunno whether
> we can dissuade the kernel from flushing its cache though.
Using open/read/write system calls, you can't. You can always use
Dear anyone,
I wish to update an entire table with just using (PostGre)SQL (=preferably without
resorting to C, Python or so). Can I? If so how?
For example, I want to update/replace table:
a | b | c
---+---+---
1 | 2 | 3
4 | 5 | 6
7 | 8 | 9
with table:
a | b | c
---+---+---
1 |
hi,
how to implement mysql's last_insert_id() ?
i know that seqences and oids are great.
the one thing i miss is that they are not session specific.
i mean selecting last_value from seqence can give me a value which was
inserted by a different user.
regards
Michal
---(
Manfred Koizar <[EMAIL PROTECTED]> writes:
> better. AFAICS Vivek's problem is that it is hard enough to hold a
> good part of the working set in the cache, and still his disks are
> saturated. Now a VACUUM not only adds one more process to disk I/O
> contention, but also makes sure that the work
Manfred Koizar <[EMAIL PROTECTED]> writes:
> Good point. What about: Whenever a backend *deletes* a tuple it
> inserts a reference to its page into the RSM? Then an entry in the
> RSM doesn't necessarily mean that the referenced page has reclaimable
> space, but it would still be valueable infor
