ERROR: syntax error at or near "select"

Question

This code gave me an ERROR: syntax error at or near "select"

SELECT name_one, name_two, jaro(
   select name from clients limit 50 as name_one, 
   select name from clients limit 50 as name_two
);

This works fine:

select jaro('aaa','aaa');

But now i need to get data from tables

Solution

Here is how you can select jaro(name1, name2) for all pairs of names:

SELECT
    t1.name as name1
,   t2.name as name2
,   jaro(t1.name, t2.name) as jaro
FROM
   (select name from clients limit 50) t1
CROSS JOIN
    (select name from clients limit 50) t2

This query uses a so-called self cross join - it produces all pairs of names from your clients table.

Comments

[Sergey Kalinichenko]

@user2983258 Apart from the call of your jaro function which you said works fine for you, the query should be fine (see its shortened version on sqlfiddle).

[Sergey Kalinichenko]

@user2983258 You are right, I was missing a FROM in the post (the demo included it, though).