postgresql - Why required "=" before ANY function with array as param, in postgres procedure? -


i answering postgres question yesterday, , came across postgres thread (here) describe following error:

error:  operator not exist: text = text[] hint:  no operator matches given name , argument type(s). might need add explicit type casts.

the error seems appear whenever array string type fed any without using = any. seems strange since based on language, logic, , sql conventions, have (e.g. in):

variable function(set)

instead of.

variable = function(set) , unless ofcourse operator summation/count operation returning 1 result :)

it make more senseto have variable any(set/array) instead of variable=any(set/array). similar example in function.

can explain going on here?

in (...) equivalent = (array[...])

crucially, any not function. it's syntax defined sql standard, , no more function group by or over clause in window function.

the reason = required before any any can apply other operators too. means "test operator left against every element in array on right, , return true if test true @ least 1 element."

you can use > (array[...]) or whatever. it's general purpose operator isn't restricted =. notably useful like any (albeit bad performance).

there all too, same thing returns true if results true.


-

Comments

Post a Comment

Popular posts from this blog

c++ - CPP, 'X' button listener -

i'm writing cpp program, , want execute function when 'x'(shut down) button pressed. for example, have infinite loop prints same thing everytime iterates, until 'x' button pressed, , want execute function before process ends. is there kind of listener matter? or other solution maybe (like delaying process shut down few seconds or something)? thanks! if want execute before process ends, can register std::atexit handler. function called before process exits.
Read more

shared memory - gstreamer shmsrc and shmsink with h264 data -

i trying share h264 encoded data gstreamer 2 processes(both based on gstreamer).after research way found use shm plugin. trying do gstreamer--->h264 encoder--->shmsink shmrc--->process1 shmrc--->process2 i able raw data videotestsrc , webcam working. h264 encoded data doesn't. test pipeline gst-launch-1.0 videotestsrc ! video/x-raw,width=640,height=480,format=yuy2 ! x264enc ! shmsink socket-path=/tmp/foo sync=true wait-for- connection=false shm-size=10000000 gst-launch-1.0 shmsrc socket-path=/tmp/foo ! avdec_h264 ! video/x- raw,width=640,height=480,framerate=25/1,format=yuy2 ! autovideosink have tried shm plugins h264 encoded data, please help iam not aware of capabilities of sink used in "autovideosink", per knowledge either need use videoconvert if format supported sink (like kmssink or ximagesink) different provided source (in case yuy2) or use videoparse if camera format supported sink. may check using gst-inspect-1...
Read more

r - Add string of (variable number of) arguments to a function within a function -

let's have function creates x number of objects based on length of input variable. want x number of objects used arguments in function supply function. assumign number of arguments variable (based on number of argument names provided), how can this? can via string of argument names perhaps? a non-working example illustrate i'm asking: (in case, using arguments created outside function simplify example): foo <- 1:5 na.rm <- t func <- mean f1 <- function(func,arg.names) { func(get(arg.names)) } f1(func,arg.names = c('foo','na.rm') how do in way get 's arguments list? we can try mget f1 <- function(func,arg.names) { lst <- mget(arg.names, envir = parent.frame()) func(lst[[1]], na.rm = lst[[2]]) } f1(func, arg.names = c('foo', 'na.rm')) #[1] 3 or option do.call (as mentioned in @thelatemail's post) change name of first list element 'x' x 'data' argument ...
Read more