I just checked that query with PDO connection in pure PHP. Query worked as expected. From here I come to decision that problem associated with Laravel. Below is full code
```
$db = new PDO("pgsql:dbname=Horecami;host=127.0.0.1", "postgres", "1" );
$sql = 'Select horeca_user.update_token(?, ?, ?)';
$stmt = $db->prepare($sql);
$type=1;
$id=1;
$z='az';
$stmt->bindValue(1, $type, PDO::PARAM_INT);
$stmt->bindValue(2, $id, PDO::PARAM_INT);
$stmt->bindValue(3, $z, PDO::PARAM_STR);
$stmt->execute();
$res=$stmt->fetchAll();
But i cannot understand why Laravel PDO instance cannot do it?
Last updated
5 years ago.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast