[HACKERS] Expression index with function based on current_user?

2006-02-08 Thread Fredrik Olsson
is it still possible to create an expression index over that function? // Fredrik Olsson ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that

[HACKERS] Inherited indexes.

2005-10-02 Thread Fredrik Olsson
to postgresql hacking might be of better use then. Or maybe it is quite easy with the right directions, as in; non complex but takes time. So some one who knows what needs to be done, but do not have the time themselves could give an outline? regards -- //Fredrik Olsson Treyst AB +46-19

[HACKERS] Underlying view columns?

2005-11-10 Thread Fredrik Olsson
used by the view in the underlying table. So there should be one row for each referenced column, should there not? If I swap objid for refobjid I do get more results, but none where objid and refobjid references to the table and view in any combination. Have I misunderstood the concept

Re: [HACKERS] Underlying view columns?

2005-11-10 Thread Fredrik Olsson
Tom Lane wrote: Fredrik Olsson <[EMAIL PROTECTED]> writes: Have I misunderstood the concept of pg_depend? Can it even be used for what I intend, and if not in what direction should I be searching next? What you missed is that the per-column dependencies you are looking for go fr

[HACKERS] MS SQL Server compatibility functions

2005-11-23 Thread Fredrik Olsson
should I continue from here in that case? regards -- //Fredrik Olsson Treyst AB +46-19-362182 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] MS SQL Server compatibility functions

2005-11-23 Thread Fredrik Olsson
Devrim GUNDUZ wrote: Hi, On Wed, 23 Nov 2005, Fredrik Olsson wrote: I guess I am not the only one moving from MS SQL Server, so is there interest for others to use my work, as a contrib perhaps. And how should I continue from here in that case? I'd start a new project at pgfoundr

Re: [HACKERS] MS SQL Server compatibility functions

2005-11-24 Thread Fredrik Olsson
Fredrik Olsson wrote: Devrim GUNDUZ wrote: Hi, On Wed, 23 Nov 2005, Fredrik Olsson wrote: I guess I am not the only one moving from MS SQL Server, so is there interest for others to use my work, as a contrib perhaps. And how should I continue from here in that case? I'd start