X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FAbstract%2FReference.pm;h=b030f39b9d387811c4f0cb26c5d6830997c84501;hb=3c700ca3444b64dccee80083cb0970d63eb7d338;hp=4752cbe410961bb555e12de2b3b69760225e40f3;hpb=f2b472371e4669fb2fc3685a7426b5c4b0f522d2;p=scpubgit%2FQ-Branch.git

diff --git a/lib/SQL/Abstract/Reference.pm b/lib/SQL/Abstract/Reference.pm
index 4752cbe..b030f39 100644
--- a/lib/SQL/Abstract/Reference.pm
+++ b/lib/SQL/Abstract/Reference.pm
@@ -695,4 +695,21 @@ not, expands the argument values:
   foo = ?
   [ 3 ]
 
+=head2 func
+
+Expands the argument values:
+
+  # expr
+  { -func => [ 'coalesce', { -ident => 'thing' }, 'fallback' ] }
+
+  # aqt
+  { -func => [
+      'coalesce', { -ident => [ 'thing' ] },
+      { -bind => [ undef, 'fallback' ] },
+  ] }
+
+  # query
+  COALESCE(thing, ?)
+  [ 'fallback' ]
+
 =cut