On Mon, Apr 15, 2013 at 7:51 PM, Tom Lane wrote:
> Rodrigo Barboza writes:
> > I created a implic cast for mytype to bigint.
> > So when I do the same query it does seq scan, because the column is
> > transformed into bigint.
>
> Yeah. One reason why there's not
On Mon, Apr 15, 2013 at 5:33 PM, Tom Lane wrote:
> Rodrigo Barboza writes:
> > I created a type 'mytype' (an unsigned int) and created an operator class
> > for index.
> > Then I created a table with a column of my type and isnerted 1000
> entries.
> >
Hi guys.
I created a type 'mytype' (an unsigned int) and created an operator class
for index.
Then I created a table with a column of my type and isnerted 1000 entries.
But no matter how many entries I have in the table, it never uses the
index. It always does a seq scan.
Here is the explain analy
On Wed, Apr 10, 2013 at 12:24 AM, Amit Kapila wrote:
>
> On Tuesday, April 09, 2013 6:19 PM Rodrigo Barboza wrote:
> On Tue, Apr 9, 2013 at 3:05 AM, Amit Kapila
> wrote:
> On Monday, April 08, 2013 7:28 PM Rodrigo Barboza wrote:
> >> You have identified rightly in your ot
On Tue, Apr 9, 2013 at 3:05 AM, Amit Kapila wrote:
> On Monday, April 08, 2013 7:28 PM Rodrigo Barboza wrote:
> On Sat, Apr 6, 2013 at 10:39 PM, Rodrigo Barboza
> wrote:
> Ok! I will try to reproduce in a smaller scenario.
> On Sat, Apr 6, 2013 at 9:53 PM, Amit Kapila
> wr
On Mon, Apr 8, 2013 at 4:30 PM, Rodrigo Barboza wrote:
>
>
>
>
> On Mon, Apr 8, 2013 at 12:14 PM, Rodrigo Barboza
> wrote:
>
>>
>>
>>
>> On Mon, Apr 8, 2013 at 11:44 AM, Rodrigo Barboza > > wrote:
>>
>>>
>>>
>>>
On Mon, Apr 8, 2013 at 12:14 PM, Rodrigo Barboza wrote:
>
>
>
> On Mon, Apr 8, 2013 at 11:44 AM, Rodrigo Barboza
> wrote:
>
>>
>>
>>
>> On Mon, Apr 8, 2013 at 11:27 AM, Rodrigo Barboza > > wrote:
>>
>>>
>>>
>>> O
On Mon, Apr 8, 2013 at 11:44 AM, Rodrigo Barboza wrote:
>
>
>
> On Mon, Apr 8, 2013 at 11:27 AM, Rodrigo Barboza
> wrote:
>
>>
>>
>> On Mon, Apr 8, 2013 at 11:25 AM, Tom Lane wrote:
>>
>>> Rodrigo Barboza writes:
>>> > UPDATE
On Mon, Apr 8, 2013 at 11:27 AM, Rodrigo Barboza wrote:
>
>
> On Mon, Apr 8, 2013 at 11:25 AM, Tom Lane wrote:
>
>> Rodrigo Barboza writes:
>> > UPDATE tm32 SET a = a + 1 WHERE a > $i;
>> > ERROR: unsupported type: 202886
>>
>> I'm be
On Mon, Apr 8, 2013 at 11:25 AM, Tom Lane wrote:
> Rodrigo Barboza writes:
> > UPDATE tm32 SET a = a + 1 WHERE a > $i;
> > ERROR: unsupported type: 202886
>
> I'm betting that's coming from scalargtsel, which doesn't know anything
> about your type, but
Ok! I will try to reproduce in a smaller scenario.
On Sat, Apr 6, 2013 at 9:53 PM, Amit Kapila wrote:
> On Saturday, April 06, 2013 12:18 PM Rodrigo Barboza wrote:
> >On Sat, Apr 6, 2013 at 12:23 AM, Amit Kapila
> wrote:
> >> On Saturday, April 06, 2013 3:57 AM
On Sat, Apr 6, 2013 at 12:23 AM, Amit Kapila wrote:
> > On Saturday, April 06, 2013 3:57 AM Rodrigo Barboza wrote:
>
> >Hello.
> > I created a type my_uint that is a unsigned int 32.
>
> > I am trying to update data of a table that contains a column of this
&g
Hello.
I created a type my_uint that is a unsigned int 32.
I am trying to update data of a table that contains a column of this type.
Here is what happens:
postgresql=> explain analyze UPDATE attribute_type_conf SET rowform =
rowform +1 where rowform <= 18;
ERROR: unsupported type: 132852
postg
ssing something
On Fri, Apr 5, 2013 at 1:12 AM, Amit Kapila wrote:
> On Thursday, April 04, 2013 8:30 PM Rodrigo Barboza wrote:
>
> > Hi guys.
> > I am wondering when I can use the PG_GETARG_UINT32 and PG_RETURN_UINT32.
> > If postgres has no unsigned int type, what i
Hi guys.
I am wondering when I can use the PG_GETARG_UINT32 and PG_RETURN_UINT32.
If postgres has no unsigned int type, what is the use of these macros?
I see, that's true.
I'm returning unknown type, there is a little more overhead. But it's
working now. =]
Thanks for the help guys!
On Wed, Apr 3, 2013 at 6:17 PM, Robert Haas wrote:
> On Wed, Apr 3, 2013 at 3:25 PM, Rodrigo Barboza
> wrote:
> > Well, I was chec
Well, I was checking inside my function the type of the second argument and
switching between the allowed types.
This way kind of does the same thing of many functions, doesn't it?
On Wed, Apr 3, 2013 at 3:39 PM, Tom Lane wrote:
> Rodrigo Barboza writes:
> > Why not useful?
Why not useful?
If I don't make it receive anyelement, I will have to create an add
function for each type.
Correct me if I'm wrong.
On Wed, Apr 3, 2013 at 2:27 PM, Robert Haas wrote:
> On Wed, Apr 3, 2013 at 11:26 AM, Rodrigo Barboza
> wrote:
> > Hello.
> > I'
Hello.
I'm trying to create a generic add function.
I have defined a type my_uint and it needs a '+' operator.
This operator should work like normal int + int operation.
The function is defined expecting arguments (my_uint, anyelement).
I'm confused in retrieving the anyelement type, value and tha
19 matches
Mail list logo
