Hai everybody,
Hai, Currently, I'm at the work of
converting database from Oracle to Postgresql. I have some
doubts:
1) What is the
equivalent of Oracle ROWNUM in Postgresql? If there is no such equivalent,
can U give me an idea about
that? 2) How
Oliver Elphick wrote:
WHERE grosysid = rec.grosysid;
Thanks, nice catch!
You exposed my lack of adequate testing. I guess I should have added a
disclaimer ;-)
Joe
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, p
On Mon, 2002-12-30 at 22:16, Joe Conway wrote:
> Rob Abernethy IV wrote:
> > Does anyone have a good recipe for a view that will display users/gruops in a
> > way that can be used with Tomcat's JDBCRelam configuration?
...
> CREATE OR REPLACE FUNCTION expand_groups() RETURNS SETOF group_view AS '
Rob Abernethy IV wrote:
Does anyone have a good recipe for a view that will display users/gruops in a
way that can be used with Tomcat's JDBCRelam configuration? In other words,
instead of seeing a *list* of users in a group (grolist), I'd like to see a
separate row for every group/user combinati
Does anyone have a good recipe for a view that will display users/gruops in a
way that can be used with Tomcat's JDBCRelam configuration? In other words,
instead of seeing a *list* of users in a group (grolist), I'd like to see a
separate row for every group/user combination.
group | user
---
Hi!
i'm actually make and audit function for use with a
trigger, in this function i want to store in a table the client's ip address,
there is any postgresql's function to obtain it? like getpgusername o
similar?
thanks in adavance...
Gabriel.
Thanks for the response. See my responses below. I'll crank it up to 1
million fsm pages. and report back when we finish with the results I
know they aren't as interesting with 7.2.3 as they would be with 7.3 but it
may help someone else.
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
[EM
Hi,
> Hm. I cannot see anything wrong with the source code for database_size.
> I notice though that it depends on vsnprintf, which is known to be buggy
> in some releases of Solaris. Did you use the patch suggested in the
> last entry of doc/FAQ_Solaris?
>
I can't find any infos about patches
